I'm trying to get this schema registered in our oracle db so we can use the XML as structured storage. I'm using 11g XE locally and 10.2g in production. I'm trying to get it loaded locally first. Here is the command i am using:
SCHEMAURL => 'http://ACORD.org/Standards/Life/2',
SCHEMADOC => bfilename('TEMP','TXLife2.28.00.xsd'),
CSID => nls_charset_id('AL32UTF8'));
And this is the error i get back:
ORA-19046: Out-of-line table cannot be shared by two top-level tables.
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 37
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 65
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 136
ORA-06512: at line 2
You can download the schema from here: http://www.chinacitystpete.com/TXLife2.28.00.xsd
Any help or suggestions would be greatly appreciated.
Added link to xsd file. Message was edited by: user5463804