ORA-30567 WHEN IMPORTING TABLE WITH LOG_GROUP EVEN IF IGNORE=Y
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 18.104.22.168 to 10.2.0.5
This problem can occur on any platform.
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.
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