DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Invalid objects ALL_XML_SCHEMAS & others

  1. #1
    Join Date
    Oct 2007
    Posts
    17

    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.

  2. #2
    Join Date
    Oct 2007
    Posts
    17
    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

  3. #3
    Join Date
    Oct 2007
    Posts
    17
    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
  •  


Click Here to Expand Forum to Full Width