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

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.2.0.5 [Release 10.2]
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:"PLUTO"]
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

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