Deinstalling XDB from a 10.2 Database Invalidates the Function SYS.IS_VPD_ENABLED

(Doc ID 1335078.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms


=== ODM Issue Clarification ===
De-installing XDB invalidates function SYS.IS_VPD_ENABLED.

Used Following document to deinstall XDB-

Master 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

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