My Oracle Support Banner

DataPump Export (EXPDP) Fails With Errors ORA-39125 ORA-942 While Calling DBMS_METADATA.FETCH_XML_CLOB (Doc ID 1497633.1)

Last updated on AUGUST 01, 2019

Applies to:

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
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 11-Feb-2015***

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.