2 Replies Latest reply: Aug 13, 2013 1:13 AM by odie_63 RSS

    XDB is invalid post registering schema


      Hi all, We have an Windows 2008R2 Oracle 11g database. I am trying to register xml schema but we now have a problem. Please advice how to resolve this: Regards, Nick SQL> select schema_url from dba_xml_schemas, dba_objects   2  where int_objname = object_name and status = 'INVALID'; SCHEMA_URL ------------------------------------------------------------------- OSDNFFeatures.xsd OSImageMetadata.xsd OSOrthoMetadata.xsd OSQueryResult.xsd OSIMIngestionMetadata.xsd OSIMProductMetadata.xsd When I try to delete it, it throws an error: BEGIN DBMS_XMLSchema.deleteSchema( schemaurl=>'/XML_SCHEMA/EGISPROD/OSDNFFeatures.xsd', delete_option=>DBMS_XMLSchema.Delete_Cascade_Force); END; / BEGIN * ERROR at line 1: ORA-31000: Resource '/XML_SCHEMA/EGISPROD/OSDNFFeatures.xsd' is not an XDB schema document ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 122 ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 106 ORA-06512: at line 2 Attempt 2; SQL> exec DBMS_XMLSCHEMA.PURGESCHEMA('3EF47FD5D23C4FB4A06E2E96DFE85D47'); BEGIN DBMS_XMLSCHEMA.PURGESCHEMA('3EF47FD5D23C4FB4A06E2E96DFE85D47'); END; * ERROR at line 1: ORA-31050: Access denied ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 109 ORA-06512: at line 1