Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid XDB schema - how to identify

68212Feb 6 2008 — edited Jul 20 2010

Hi,
My xdb schema has an invalid object, that according to user_objects is a XML schema:

select OBJECT_NAME,OBJECT_TYPE
from user_objects
where status != 'VALID';

OBJECT_NAME                      OBJECT_TYPE
------------------------------  -------------------
XDP5cTdCiCA6LgQOIKIAQUHQ==       XML SCHEMA

But I cannot figure out which schema it is, the object_name value looks like it should appear in user_xml_schemas.int_objname, but there are no matches. Where do I need to look?

Thanks

Pete

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 17 2010
Added on Feb 6 2008
10 comments
10,028 views