ERROR
When indexing Oracle Spatial tables, like this:SQL> CREATE INDEX Q2Q_POINT1_IDX
SQL> ON Q2Q_POINT1(SHAPE)
SQL> INDEXTYPE IS MDSYS.SPATIAL_INDEX;The following error occurs:ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13203: failed to read USER_SDO_GEOM_METADATA table
ORA-13203: failed to read USER_SDO_GEOM_METADATA table
ORA-06512: at "MDSYS.SDO_INDEX_METHOD", line 7
ORA-06512: at line 1
In ALL_SDO_GEOM_METADATA, there is no row specifying this particular combination of OWNER, TABLE_NAME and (geometry) COLUMN_NAME.
Article ID:000004361
Get help from ArcGIS experts
Download the Esri Support App