I am using Oracle 11g (Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production) and I have a table that has column of type SDO_GEOMETRY. I want to create a spatial index on this column (NEW_SHAPE). My query is as following:
CREATE INDEX GIS_GEOM_SRID3857_SPTIDX ON GIS_GEOM_SRID3857_LOOKUP ( NEW_SHAPE ) INDEXTYPE IS MDSYS.SPATIAL_INDEX; /
and I am getting the following errors:
Error starting at line : 23 in command - CREATE INDEX GIS_GEOM_SRID3857_SPTIDX ON GIS_GEOM_SRID3857_LOOKUP ( NEW_SHAPE ) INDEXTYPE IS MDSYS.SPATIAL_INDEX Error report - ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-13249: SRID 3857 does not exist in MDSYS.CS_SRS table ORA-29400: data cartridge error Error - OCI_NODATA ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10 29855. 00000 - "error occurred in the execution of ODCIINDEXCREATE routine" *Cause: Failed to successfully execute the ODCIIndexCreate routine. *Action: Check to see if the routine has been coded correctly.
I have searched on these errors but have not found anything useful. What is the problem here?