I used the following statement to try and create a spatial index on a table but I got a long list of errors (also listed).. Can anyone help???
The index name does not alreay exist and there is no index on the table.
I have also successfully created an entry in the user_sdo_geom_metadata table.
CREATE INDEX MY_GEOMIDX ON new_table(GEOM)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13249: Error in spatial index: [mdrcrtxfergm]
ORA-13249: Error in spatial index: [mdpridxtxfergm]
ORA-13200: internal error [ROWID:AAAKvDAAJAAAEHvAAA] in spatial indexing.
ORA-13206: internal error  while creating the spatial index
ORA-13365: Layer SRID does not match geometry SRID
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 7
ORA-06512: at line 1