My Oracle Support Banner

Full database export at pdb level failing with ORA-00942: table or view does not exist ( Unable to access DV related Views) (Doc ID 2770121.1)

Last updated on MAY 02, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Full database export of PDB failing with ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [ORA-00942: table or view does not exist

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 12630
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 9571
ORA-06512: at "SYS.DBMS_METADATA", line 2976
ORA-06512: at "SYS.DBMS_METADATA", line 3608
ORA-06512: at "SYS.DBMS_METADATA", line 5008
ORA-06512: at "SYS.DBMS_METADATA", line 5327
ORA-06512: at "SYS.DBMS_METADATA", line 9552
ORA-06512: at "SYS.KUPW$WORKER", line 15119
----- PL/SQL Call Stack -----
object line object
handle number name
0x62ead2a0 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x62ead2a0 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x62ead2a0 15452 package body SYS.KUPW$WORKER.FETCH_XML_OBJECTS
0x62ead2a0 3917 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x62ead2a0 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x62ead2a0 2439 package body SYS.KUPW$WORKER.MAIN
0x64143a78 2 anonymous block

Enabling tracing for ORA-00942 error with:

SQL> alter system set events '942 trace name errorstack level 12';
has helped to determine that the DVSYS.KU$_DV_ISR_VIEW KU$ view is missing in PDB.

In this case, the generated trace file shows:

----- Error Stack Dump -----
<error barrier> at 0x7ffdb5c205a0 placed dbkda.c@296
<error barrier> at 0x7ffdb5c35f80 placed kpoodr.c@237
----- Current SQL Statement for this session (sql_id=6rkx70f3161ct) -----
SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('DVPS_IMPORT_STAGING_REALM_T', '7')), 0 ,'DVPS_IMPORT_STAGING_REALM'
FROM DVSYS.KU$_DV_ISR_VIEW KU$



Changes

 This database was plugged into cdb with data vault

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


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