My Oracle Support Banner

Datapump Export (EXPDP) of New Plugged Database Fails With Error ORA-00942 (Doc ID 2369062.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

12.2 DataPump Export of new plugged database (PDB) fails with error ORA-00942:

expdp system/password@PDB1 DIRECTORY=EXPORT_DIR LOGFILE=export_dir:dmp.log DUMPFILE=aime.dmp FULL=Y CONTENT=METADATA_ONLY

Error details:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS
[ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 12098
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 9039
ORA-06512: at "SYS.DBMS_METADATA", line 2792
ORA-06512: at "SYS.DBMS_METADATA", line 3423
ORA-06512: at "SYS.DBMS_METADATA", line 4760
ORA-06512: at "SYS.DBMS_METADATA", line 5079
ORA-06512: at "SYS.DBMS_METADATA", line 9020
ORA-06512: at "SYS.KUPW$WORKER", line 14367

0x7bbe26a0 2 anonymous block
DBMS_METADATA.SET_FILTER

 

Changes

The PDB was recently plugged into the Container Database.

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!


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