DataPump Export Fails With Errors ORA-39125 ORA-31642 ORA-1422 (Doc ID 790988.1)

Last updated on APRIL 23, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Apr-2013***

Symptoms

DataPump export (EXPDP) fails with the following errors:

#> expdp system/passworde schemas=scott content=metadata_only dumpfile=scott.dmp

 

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB []
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_SCHED_EXPORT_CALLOUTS".SCHEMA_CALLOUT(:1,1,1,'10.02.00.03.00') ; END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 907
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6228
----- PL/SQL Call Stack -----
object line object
handle number name
0x239ced9c 14916 package body SYS.KUPW$WORKER
0x239ced9c 6293 package body SYS.KUPW$WORKER
0x239ced9c 2339 package body SYS.KUPW$WORKER
0x239ced9c 6854 package body SYS.KUPW$WORKER
0x239ced9c 1259 package body SYS.KUPW$WORKER
0x308382a8 2 anonymous block

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