My Oracle Support Banner

ORA-30567 WHEN IMPORTING TABLE WITH LOG_GROUP EVEN IF IGNORE=Y (Doc ID 780297.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.7 to 10.2.0.5 [Release 9.2 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Import is getting the following errors using 'imp' utility:

imp file=expregsmall-20090106.dmp fromuser=<USER_NAME> touser=<USER_NAME> ignore=y
commit=y buffer=4000000 indexes=n constraints=n grants=n ignore=y

"ALTER TABLE "<TABLE_NAME>" ADD SUPPLEMENTAL LOG GROUP "<LOG_GROUP>" ("<COLUMN_NAME1>"
"<COLUMN_NAME2>", "<COLUMN_NAME3>", "<COLUMN_NAME4>", "<COLUMN_NAME5>", "<COLUMN_NAME6>") ALWAYS"
IMP-00003: ORACLE error 30567 encountered
ORA-30567: name already used by an existing log group

With ignore=y set these types of errors should be ignored.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.