My Oracle Support Banner

ORA-39083: Object Type Synonym ORA-600: [kkdlInvalidateSynonyms2.3] During DataPump Import (Doc ID 1910932.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.

Symptoms

NOTE: The document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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], [], [], [], [], [], [], [], [], [],[]

 

Changes

 NONE

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.