Hi,
In the Multitenant architecture, it’s common to have some components installed on the CDB but not installed on the PDB. But for Database Vault, you can have some issues.
I was doing a Full export from one PDB and I got the error: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [ORA-00942: table or view does not exist
On the first search, I found this note on MOS: 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)
“Currently having DV installed in the root of a CDB database, but not present in a PDB of that database is not supported (for full database export).”
CDB:
PDB:
Basically, to fix it, connect to the PDB and run @$ORACLE_HOME/rdbms/admin/catmac.sql
If you don’t have the OLS on the PDB you will also need to install it first: @$ORACLE_HOME/rdbms/admin/catols.sql
In the 21c, there is some new information about it, but I didn’t test yet: