Problems creating a spatial index
I have tried to create spatial indexes the same way that the MapInfo Easy Loader does but when I issue the following sql:
CREATE INDEX SPATIAL.TEST_TABLE3_SX ON
"SPATIAL".TEST_TABLE3(GEOMETRY)
TABLESPACE SYSTEM PCTFREE 0
I get the following error message:
The following error has occurred:
ORA-02327: cannot create index on expression with datatype ADT
Which is described further in the Oracle documentation as follows:
ORA-02327 cannot create index on expression with datatype string
Cause: An attempt was made to create an index on a non-indexable expression.
Action: Change the column datatype or do not create the index on an expression whose datatype is one of VARRAY, nested table, object, LOB, or REF.
It seems as if spatial indexing can not be performed on the GEOMETRY column. However, both columns, GEOMETRY or GEOLOC, in each table, TEST_TABLE3 created by my java app and TEST4 created by EasyLoader, has the same type: SDO_GEOMTRY.
How do I go about creating the spatial index?