DataPump Export (EXPDP) Errors ORA-31693 ORA-2019 Over NETWORK_LINK With PARALLEL > 1 (Doc ID 467950.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 28-AUG-2013***

Symptoms

When using expdp over a network link with parallel > 1, you receive the error:

ORA-31693: Table data object "ADSR_BO"."BO_HKEX_FO_POSITION" failed to load/unload and is being skipped due to error:
ORA-02019: connection description for remote database not found
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

If the database link is a public link instead of private, then it fails with following messages instead of ORA-2019:

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW02" prematurely terminated
ORA-31671: Worker process DW02 had an unhandled exception.
ORA-12801: error signaled in parallel query server
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-29400: data cartridge error
KUP-04038: internal error: kupax-meta1
ORA-6512: at "SYS.ORACLE_DATAPUMP", line 78
ORA-6512: at "SYS.KUPW$WORKER", line 1345

With parallel=1 or without the parallel option, expdp works without a problem.

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