0 Replies Latest reply: Jun 25, 2013 5:28 PM by user5463804 RSS

    Need help getting large schema registered in database ORA-19046


      Hi All,


      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:


      Error report:

      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