I have a column SDO_GEOMERTY type.But i have some problems with installation i think.Research a lot of solutions but still get the error about creating index.
For below solution ODCIINDEXCREATE get the error but i could see the added value already in user_sdo_geom_metadata. http://qdosmsq.dunbar-it.co.uk/blog/2013/05/spatial-indexes-and-oracle-errors-how-to-fix/
--Inserting USer_SDO_GEOM_METADATA
INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES ('MY_TABLE', 'MY_COLUMN',
MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('LONG', -180.0, 180.0, 0.005),
MDSYS.SDO_DIM_ELEMENT('LAT', -90.0, 90.0, 0.005)
),
8307);
COMMIT;
----------------------------------------------
SELECT * FROM USER_SDO_GEOM_METADATA
WHERE TABLE_NAME = 'MY_TABLE'
AND COLUMN_NAME = UPPER('MY_COLUMN');
--1 ROW
----------------------------------------
CREATE INDEX SPATIAL_MY_TABLE_IDX ON MY_TABLE(MY_COLUMN)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;
INDEX was created but showing below message.
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13203: failed to read USER_SDO_GEOM_METADATA view
ORA-13203: failed to read USER_SDO_GEOM_METADATA view
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
-------------------------------------------------------------------
And when i query the statement with SDO_EQUAL function then show below error message
ORA-13226: interface not supported without a spatial index
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 8
ORA-06512: at "MDSYS.SDO_3GL", line 88
ORA-06512: at "MDSYS.SDO_3GL", line 529