I have registered an XMLschem in Oracle XDB repository to load XML file into oracle tables using object relational storage. In this process I am trying to
delete the xmlschema to register it again with some changes to the XSD file,but I am not able to delete it and I keep getting the ORA error 04022 no wait
requested, but had to wait to lock dictionary objects.. Before this I have deleted the xmlschem 2-3 times and it worked fine. But now I get the this error.
I tried to delete it with 'DELETE_CASCADE' and also tried 'DELETE_CASCADE_FORCE' and in both cases i get the same error.
I waited for 2-3 days and then retried still got the same error.
Could you please help me with resolving this issue.
Below is the screenshot of the error
Also I tried to purge the schema, but I get the Access Denied error. I am stuck at this point, couldn't move forward
select * from dba_xml_schemas where qual_schema_url like '%HPO484%'; -- 1B01B74F95BE1C91E0540021287E70DC
BEGIN
DBMS_XMLSCHEMA.PURGESCHEMA(schema_id =>'1B01B74F95BE1C91E0540021287E70DC');
END;
It throws below error
ORA-31050: Access denied
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 109
ORA-06512: at line 1
Could you please help me with this.
Thanks,
Reva
.