Invalid KU$ Views and CATALOG, CATPROC components after XDB Deinstall in 10.2 (Doc ID 1375280.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Sep-2014***

Symptoms

After the clean  deinstallation of XDB (XML Database) on a 10.2 database following objects become invalid-

OWNER OBJECT_NAME OBJECT_TYPE
--------------- ---------------------------------------- --------------------
SYS ALL_XML_SCHEMAS VIEW
SYS ALL_XML_SCHEMAS2 VIEW
SYS KU$_10_1_FHTABLE_VIEW VIEW
SYS KU$_10_1_IOTABLE_VIEW VIEW
SYS KU$_10_1_PFHTABLE_VIEW VIEW
SYS KU$_10_1_PIOTABLE_VIEW VIEW
SYS KU$_CLUSTER_VIEW VIEW
SYS KU$_COLUMN_VIEW VIEW
SYS KU$_FHTABLE_VIEW VIEW
SYS KU$_IOTABLE_VIEW VIEW
SYS KU$_M_VIEW_FH_VIEW VIEW
SYS KU$_M_VIEW_IOT_VIEW VIEW
SYS KU$_M_VIEW_LOG_FH_VIEW VIEW
SYS KU$_M_VIEW_LOG_PFH_VIEW VIEW
SYS KU$_M_VIEW_PFH_VIEW VIEW
SYS KU$_M_VIEW_PIOT_VIEW VIEW
SYS KU$_NT_PARENT_VIEW VIEW
SYS KU$_OPQTYPE_VIEW VIEW
SYS KU$_PCOLUMN_VIEW VIEW
SYS KU$_PFHTABLE_VIEW VIEW
SYS KU$_PIOTABLE_VIEW VIEW
SYS KU$_VIEW_VIEW VIEW
SYS KU$_XMLSCHEMA_ELMT_VIEW VIEW
SYS KU$_XMLSCHEMA_VIEW VIEW

24 rows selected.

Try to compile these invalid views by running "?/rdbms/admin/utlrp.sql" but the views are still invalid and now both CATALOG and CATPROC components in DBA_REGISTRY also become invalid, i.e.-

SQL> select comp_name,comp_id, status, version from dba_registry;

COMP_NAME COMP_ID STATUS VERSION
----------------------------------- ---------- --------------- ---------------
Oracle Database Catalog Views CATALOG INVALID 10.2.0.4.0
Oracle Database Packages and Types CATPROC INVALID 10.2.0.4.0

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