Invalid objects ALL_XML_SCHEMAS & others
Hi ALL,
Created two blank archive databases few weeks back, recompiled invalid objects using utlrp.sql. Even then i see the below xml and meterialized views objects invalid.
OWNER OBJECT_TYPE OBJECT_NAME LAST_DDL_TIME STATUS
-------------------- ------------------ ------------------------------ ------------------- -------
SYS VIEW ALL_XML_SCHEMAS 10/31/2007 13:47:22 INVALID
SYS VIEW ALL_XML_TABLES 10/31/2007 13:47:21 INVALID
SYS VIEW ALL_XML_TAB_COLS 10/31/2007 13:47:21 INVALID
SYS VIEW ALL_XML_VIEWS 10/31/2007 13:47:21 INVALID
SYS VIEW ALL_XML_VIEW_COLS 10/31/2007 13:47:22 INVALID
SYS VIEW DBA_XML_SCHEMAS 10/31/2007 13:47:22 INVALID
SYS VIEW DBA_XML_TABLES 10/31/2007 13:47:21 INVALID
SYS VIEW DBA_XML_TAB_COLS 10/31/2007 13:47:21 INVALID
SYS VIEW KU$_OPQTYPE_VIEW 10/31/2007 13:47:59 INVALID
SYS VIEW KU$_PFHTABLE_VIEW 10/31/2007 13:48:01 INVALID
SYS VIEW KU$_PIOTABLE_VIEW 10/31/2007 13:48:01 INVALID
SYS VIEW KU$_VIEW_VIEW 10/31/2007 13:48:02 INVALID
SYS VIEW KU$_XMLSCHEMA_ELMT_VIEW 10/31/2007 13:47:22 INVALID
SYS VIEW KU$_XMLSCHEMA_VIEW 10/31/2007 13:47:22 INVALID
SYS VIEW USER_XML_SCHEMAS 10/31/2007 13:47:22 INVALID
SYS VIEW USER_XML_TABLES 10/31/2007 13:47:21 INVALID
SYS VIEW USER_XML_TAB_COLS 10/31/2007 13:47:21 INVALID
SYS VIEW USER_XML_VIEWS 10/31/2007 13:47:21 INVALID
SYS VIEW USER_XML_VIEW_COLS 10/31/2007 13:47:22 INVALID
XDB PACKAGE BODY DBMS_XDB 10/31/2007 13:47:11 INVALID
XDB PACKAGE BODY DBMS_XDB_VERSION 10/31/2007 13:48:03 INVALID
XDB PROCEDURE XDB$PATCHUPDELETESCHEMA 10/31/2007 13:47:09 INVALID
XDB PROCEDURE XDB$PATCHUPSCHEMA 10/31/2007 13:47:09 INVALID
**************************************************
I browsed thru google but no help.
Is there a way to get these objects back to valid state.
Thanks in advance.
Dropped xml packages and recreated them.
when i checked for invalid objects it still have:
OWNER OBJECT_TYPE OBJECT_NAME LAST_DDL_TIME STATUS
-------------------- ------------------ ------------------------------ ------------------- -------
SYS VIEW KU$_CLUSTER_VIEW 10/31/2007 12:54:22 INVALID
SYS VIEW KU$_COLUMN_VIEW 10/31/2007 12:54:20 INVALID
SYS VIEW KU$_FHTABLE_VIEW 10/31/2007 12:54:20 INVALID
SYS VIEW KU$_IOTABLE_VIEW 10/31/2007 12:54:21 INVALID
SYS VIEW KU$_M_VIEW_FH_VIEW 10/31/2007 12:54:21 INVALID
SYS VIEW KU$_M_VIEW_IOT_VIEW 10/31/2007 12:54:22 INVALID
SYS VIEW KU$_M_VIEW_LOG_FH_VIEW 10/31/2007 12:54:22 INVALID
SYS VIEW KU$_M_VIEW_LOG_PFH_VIEW 10/31/2007 12:54:22 INVALID
SYS VIEW KU$_M_VIEW_PFH_VIEW 10/31/2007 12:54:21 INVALID
SYS VIEW KU$_M_VIEW_PIOT_VIEW 10/31/2007 12:54:22 INVALID
SYS VIEW KU$_NT_PARENT_VIEW 10/31/2007 12:54:20 INVALID
SYS VIEW KU$_OPQTYPE_VIEW 10/31/2007 12:54:19 INVALID
SYS VIEW KU$_PFHTABLE_VIEW 10/31/2007 12:54:21 INVALID
SYS VIEW KU$_PIOTABLE_VIEW 10/31/2007 12:54:21 INVALID
SYS VIEW KU$_VIEW_VIEW 10/31/2007 12:54:21 INVALID
Hi all,
I recompiled those objects and now there are no invalid objects.
thanks
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width
Bookmarks