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


:cool:

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