-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|