Creating spatial index.

First of all , We need to insert a value in MDSYS.USER_SDO_GEOM_METADATA


Creating spatial index syntax.


CREATE INDEX ADDRESSES_SIDX ON ADDRESS
(OGC_GEOMETRY)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS('layer_gtype=point')
NOPARALLEL;


give gtype as your spatial value


In the above example gtype is point.Means 2001 in table.