DataPump Network_Link Import (IMPDP) Fails With ORA-904("KU$"."SCHEMA_OBJ"."NAME") (Doc ID 2296695.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

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

Symptoms

The error ORA-904 is raised when running DataPump network_link import.

The complete error message looks like:

$ impdp tc/tc@p1 network_link=db11204 directory=dpdir tables=tc.t1 trace=1ff0300

Import: Release 12.2.0.1.0 - Production on Mon Jun 26 15:23:15 2017

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 -
64bit Production
Starting "TC"."SYS_IMPORT_TABLE_01": tc/********@p1 network_link=db11204 directory=dpdir tables=tc.t1 trace=1ff0300
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS
[ORA-00904: "KU$"."SCHEMA_OBJ"."NAME": invalid identifier

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 12092
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_METADATA", line 9039
ORA-06512: at "SYS.DBMS_METADATA", line 4861
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 4854
ORA-06512: at "SYS.DBMS_METADATA", line 5115
ORA-06512: at "SYS.DBMS_METADATA", line 9020
ORA-06512: at "SYS.KUPW$WORKER", line 14367

----- PL/SQL Call Stack -----
object line object
handle number name
0x672b7a58 32239 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x672b7a58 12119 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x672b7a58 14693 package body SYS.KUPW$WORKER.FETCH_XML_OBJECTS
0x672b7a58 3689 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x672b7a58 13063 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x672b7a58 2311 package body SYS.KUPW$WORKER.MAIN


The trace file generated with trace=1ff0300, shows the following failing statement:

 

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