IMPDP Raises ORA-39126 And ORA-2041 When Using NETWORK_LINK (Doc ID 1493900.1)

Last updated on JULY 01, 2015

Applies to:

Oracle Database - Standard Edition - Version 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 07-Oct-2014***

Symptoms

1. Performing an IMPDP with the use of NETWORK_LINK results in:

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
ORA-02041: client database did not begin a transaction

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8353


2. The IMPDP parameters used include:

directory=export
transform=oid:n
parallel=16
metrics=y
schemas=P_FZ
FLASHBACK_TIME="TO_TIMESTAMP(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')"
NETWORK_LINK=FZ2ODA
TABLE_EXISTS_ACTION=APPEND
remap_schema=P_FZ:RA1
remap_tablespace=P_FZ_DATA:RA_DATA
remap_tablespace=P_FZ_LOB:RA_LOB


3. Review of the generated tracefiles reveals a current SQL statement similar to:

----- Error Stack Dump -----
ORA-02041: client database did not begin a transaction
ORA-02063: preceding line from FZ2ODA
----- Current SQL Statement for this session (sql_id=3xujthq3zk55d) -----
BEGIN :1 := dbms_metadata.network_fetch_clob@FZ2ODA(:2,:3,:4,:5,:6,:7); END;

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