6 Replies Latest reply: Sep 20, 2013 8:47 AM by SirDrinksalot RSS

    LAYER_GTYPE when elements are SDO_GTYPE 3008

    630089
      I am trying to build a spatial index which needs to specify the LAYER_GTYPE parameter for a table that has elements of SDO_GTPE 3008. So far I have tried specifying the GTYPE as SOLID, COMPOUND, MULTICOMPOUND, and MULTIPOLYGON. Nothing seems to work. Can anyone suggest how to specify LAYER_GTYPE for a 3008 element?

      example attempts:

      CREATE INDEX CITY_BUILDINGS_SIDX ON CITY_BUILDINGS (GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3 LAYER_GTYPE=SOLID');
      ORA-13376: invalid type name specified for layer_gtype parameter

      CREATE INDEX CITY_BUILDINGS_SIDX ON CITY_BUILDINGS (GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3 LAYER_GTYPE=MULTIPOLYGON');
      ORA-13375: the layer is of type [3007] while geometry inserted has type [3008]

      CREATE INDEX CITY_BUILDINGS_SIDX ON CITY_BUILDINGS (GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS ('sdo_indx_dims=3 LAYER_GTYPE=MULTICOMPOUND');
      ORA-13376: invalid type name specified for layer_gtype parameter

      Thanks
      -mcslain