DataPump Import (IMPDP) With NETWORK_LINK Fails With Errors ORA-39126 ORA-31600 (Doc ID 1380752.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Feb-2015***

Symptoms

When trying to perform a DataPump import using the NETWORK_LINK command line parameter, the following errors are raised:

ORA-03113: end-of-file on communication channel
ORA-02063: preceding line from PNX8A
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS [INDEX:"AEO"."AEO_REGION_GROUPS_UK1"]
ORA-31600: invalid input value 200001 for parameter HANDLE in function CLOSE
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 555
ORA-06512: at "SYS.DBMS_METADATA", line 4279
ORA-06512: at "SYS.DBMS_METADATA", line 1076
ORA-06512: at "SYS.DBMS_METADATA", line 5570
ORA-06512: at "SYS.KUPW$WORKER", line 2788
ORA-31600: invalid input value 200001 for parameter HANDLE in function NETWORK_FETCH_CLOB
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 555
ORA-06512: at "SYS.DBMS_METADATA", line 3923

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