DataPump Export (EXPDP) Fails With Errors ORA-39125 ORA-942 While Calling DBMS_METADATA.FETCH_XML_CLOB
(Doc ID 1497633.1)
Last updated on OCTOBER 08, 2022
Applies to:
Oracle Database Backup Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.2.0.5 [Release 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
When running DataPump export, it fails with errors like the following:
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [PROCACT_SCHEMA:"<SCHEMA_NAME>"]
ORA-00942: table or view does not exist
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
39a800a20 14916 package body SYS.KUPW$WORKER
39a800a20 6293 package body SYS.KUPW$WORKER
39a800a20 2339 package body SYS.KUPW$WORKER
39a800a20 6854 package body SYS.KUPW$WORKER
39a800a20 1259 package body SYS.KUPW$WORKER
397ab4730 2 anonymous block
ORA-00942: table or view does not exist
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
39a800a20 14916 package body SYS.KUPW$WORKER
39a800a20 6293 package body SYS.KUPW$WORKER
39a800a20 2339 package body SYS.KUPW$WORKER
39a800a20 6854 package body SYS.KUPW$WORKER
39a800a20 1259 package body SYS.KUPW$WORKER
397ab4730 2 anonymous block
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |