Deinstalling XDB from a 10.2 Database Invalidates the Function SYS.IS_VPD_ENABLED
(Doc ID 1335078.1)
Last updated on JUNE 12, 2021
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database Backup Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
Symptoms
De-installing XDB invalidates function SYS.IS_VPD_ENABLED.
Used Following document to deinstall XDB-
Primary Note for Oracle XML Database (XDB) Install / Deinstall (Doc ID 1292089.1)
Cleaned up Invalid SYS objects caused due to XDB removal using the steps from below note -
Invalid KU$ Views and CATALOG, CATPROC components after XDB Deinstall in 10.2 (Doc ID 1375280.1)
Still have one invalid object after all steps are completed:
OWNER OBJECT_NAME OBJECT_TYPE STATUS
------------------------------ --------------- ------------------- -------
SYS IS_VPD_ENABLED FUNCTION INVALID
Recompilation shows that it is dependent on an XDB object which no longer exists since XDB schema was dropped -
SQL> alter function IS_VPD_ENABLED compile;
Warning: Function altered with compilation errors.
SQL> show errors
Errors for FUNCTION IS_VPD_ENABLED:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
4/43 PLS-00201: identifier 'DBMS_XDBZ.IS_ENABLED_CONTENTS' must be declared
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 |
| Cause |
| Solution |
| References |