This discussion is archived
6 Replies Latest reply: Sep 20, 2013 6:47 AM by SirDrinksalot RSS

LAYER_GTYPE when elements are SDO_GTYPE 3008

630089 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points