DataPump Export (EXPDP) Fails With Errors ORA-39125 ORA-904 ORA-6512 SYS.DBMS_SYS_ERROR (Doc ID 457261.1)

Last updated on JULY 13, 2016

Applies to:

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

Symptoms

DataPump exports - full, schema level or table mode - fail with errors like below:

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB
ORA-00904: : invalid identifier
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6234

----- PL/SQL Call Stack -----
object line object
handle number name
1CB5D140 14916 package body SYS.KUPW$WORKER
1CB5D140 6293 package body SYS.KUPW$WORKER
1CB5D140 2339 package body SYS.KUPW$WORKER
1CB5D140 6854 package body SYS.KUPW$WORKER
1CB5D140 1259 package body SYS.KUPW$WORKER
1CB3952C 2 anonymous block


For example:

#> expdp scott/tiger dumpfile=expdp_dir:test.dmp logfile=expdp_dir:test.log

 

Export: Release 10.2.0.3.0 - Production on Wednesday, 05 September, 2007 11:41:28

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SCOTT"."SYS_EXPORT_SCHEMA_01": scott/******** dumpfile=expdp_dir:test.dmp logfile=expdp_dir:test.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 256 KB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [PROCACT_SCHEMA:"SCOTT"]
ORA-00904: : invalid identifier
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6234

----- PL/SQL Call Stack -----
object line object
handle number name
1CB5D140 14916 package body SYS.KUPW$WORKER
1CB5D140 6293 package body SYS.KUPW$WORKER
1CB5D140 2339 package body SYS.KUPW$WORKER
1CB5D140 6854 package body SYS.KUPW$WORKER
1CB5D140 1259 package body SYS.KUPW$WORKER
1A320B28 2 anonymous block

Job "SCOTT"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 11:41:42

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