DataPump Export (EXPDP) Errors ORA-31693 ORA-2019 Over NETWORK_LINK With PARALLEL > 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***
When using expdp over a network link with parallel > 1, you receive the 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:
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.
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