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

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.7 to 10.2.0.5
This problem can occur on any platform.

Symptoms

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

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

"ALTER TABLE "REG_NAMES" ADD SUPPLEMENTAL LOG GROUP "NMS_COLS2" ("LAST_MAINT"
"_DT_TM", "ERROR_CODE", "ROW_XNG_DT", "ROW_XNG_USR", "ROW_STATUS") 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.


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms