Restore iSetup specific XMLTYPE columns by executing /azhAddDiffCol.sql script error out
while completing the steps in How to Cleanup Invalid Oracle iSetup (AZ) Tables [ID 832459.1] following step error out,
SQL> alter table AZ_DIFF_RESULTS add (attr_diff sys.XMLType) xmltype column attr_diff
2 STORE as CLOB XMLSCHEMA "http://isetup.oracle.com/2006/diffresultdata.xsd" element "H";
alter table AZ_DIFF_RESULTS add (attr_diff sys.XMLType) xmltype column attr_diff
*
ERROR at line 1:
ORA-31000: Resource 'http://isetup.oracle.com/2006/diffresultdata.xsd' is not
an XDB schema document
0