Invalid Obects after creating 9iR2 -Db
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Invalid Obects after creating 9iR2 -Db

  1. #1
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448

    Wink Invalid Obects after creating 9iR2 -Db

    Windows 2000 SP3,
    Oracle EE 9.2.x

    Hi,
    I created all db-create-scripts with the dbassistant.
    After finishing db-creation the db show error after reboot :

    Table or View does not exists.

    It seems to be an error with XMLDB.

    The invalid objects are :

    OWNER OBJECT_NAME OBJECT_TYPE
    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$_PFHTABLE_VIEW VIEW
    SYS KU$_PIOTABLE_VIEW VIEW
    SYS KU$_VIEW_VIEW VIEW
    SYS KU$_XMLSCHEMA_ELMT_VIEW VIEW

    and the most invalid view is :

    create or replace view ku$_xmlschema_elmt_view of sys.ku$_xmlschema_elmt_t with object oid (schemaoid, elemnum) as
    select schm.sys_nc_oid$, extractValue(value(schm), '/schema/@schemaURL'),
    extractValue(value(xel), '/element/@propNumber'),
    extractValue(value(xel), '/element/@name')
    from xdb.xdb$element xel, xdb.xdb$schema schm
    where ref(schm) = extractValue(value(xel), '/element/@parentSchema')


    i think the sys.ku$_xmlschema_elmt_t is missing

    Has anybody an idea what to do?

    Thanks in advice

    Orca



  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448

    Thumbs up

    Hi,
    The XDB-Tablespace was to small!
    * i resized the datafile and rereun the script
    * but the error remained

    * i reinstalled the database complete with larger XDB-Tablspace
    and no error!

    Ciao
    Orca

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