ORA-39083: Object Type Synonym ORA-600: [kkdlInvalidateSynonyms2.3] During DataPump Import

(Doc ID 1910932.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

You performed a full or schema DataPump export. Trying to import the dumpfile, it fails like below:

impdp '"/ as sysdba"' SCHEMAS=ABC  REMAP_SCHEMA=ABC:XYZ DIRECTORY=DP DUMPFILE=ABC_06212014_01.dmp LOGFILE=ABC.log Job_name=ABC

ORA-39083: Object type SYNONYM failed to create with error:
ORA-00600: internal error code, arguments: [kkdlInvalidateSynonyms2.3], [147418], [], [], [], [], [], [], [], [], [], []


The trace file shows the failing statement like:

 ----- Current SQL Statement for this session (sql_id=4fmuc7c4cfck3) -----
CREATE SYNONYM "<SYNONYM_NAME" FOR "<OWNER>.<TABLE_NAME>"


The PL/SQL and function call stack appear in the trace file like:

----- PL/SQL Call Stack -----
object line object
handle number name
70000005e38c3a8 16527 package body SYS.KUPW$WORKER
70000005e38c3a8 15677 package body SYS.KUPW$WORKER
70000005e38c3a8 15408 package body SYS.KUPW$WORKER
70000005e38c3a8 4065 package body SYS.KUPW$WORKER
70000005e38c3a8 9082 package body SYS.KUPW$WORKER
70000005e38c3a8 1688 package body SYS.KUPW$WORKER
700000064619a28 2 anonymous block


----- Call Stack Trace -----
skdstdst ksedst1 ksedst dbkedDefDump ksedmp ksfdmp dbgexPhaseII dbgexProcessError dbgeExecuteForError dbgePostErrorKGE 1152 dbkePostKGE_kgsf kgeadse kgerinv_internal kgerinv kgeasnmierr kkdlInvalidateSynon yms kkdlInvalidateOnObj Creation kkdlcob Creation csydrv opiexe opiosq0 opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr kpoodr upirtrc kpurcsc kpuexec OCIStmtExecute kupprwp ksvrdp opirip opidrv sou2o opimai_real ssthrdmain main


An explicit 'create SYNONYM' also fails with the same ORA-600:

SQL> CREATE SYNONYM M "<SYNONYM_NAME" FOR "<OWNER>.<TABLE_NAME>"
CREATE SYNONYM PRODUCT_LG.CPFXP_CONTRACT FOR PRODUCT_ISG.CPFXP_CONTRACT
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkdlInvalidateSynonyms2.3], [147418], [], [], [], [], [], [], [], [], [],[]

 

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