2 Replies Latest reply on Sep 25, 2013 6:58 AM by don123

    error in adding layer


      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