-
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
|