2 Replies Latest reply: Sep 25, 2013 1:58 AM by don123 RSS

    error in adding layer

    don123

      hi, working with oracle 11g, trying to add layer to topology, please help me to resolve this.

       

      SQL> execute sdo_topo.add_topo_geometry_layer('USSTATES', 'TOPO_US_STATES', 'FEATURE', 'POLYGON');
      BEGIN sdo_topo.add_topo_geometry_layer('USSTATES', 'TOPO_US_STATES', 'FEATURE',
      'POLYGON'); END;

      *
      ERROR at line 1:
      ORA-13199: Relation table does not have matching partition for existing  data
      in the table TOPO_US_STATES
      ORA-06512: at "MDSYS.MD", line 1723
      ORA-06512: at "MDSYS.MDERR", line 17
      ORA-06512: at "MDSYS.SDO_TOPO", line 872
      ORA-06512: at "MDSYS.SDO_TOPO", line 1057
      ORA-06512: at line 1

       

      regards