English

Error: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

Error Message

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

Cause

In ALL_SDO_GEOM_METADATA, there is no row specifying this particular combination of OWNER, TABLE_NAME and (geometry) COLUMN_NAME.

Solution or Workaround

  1. Check for a row (mistakenly inserted into ALL_SDO_GEOM_METADATA) in which one or more of these columns is incorrect.
  2. Insert a new row into USER_SDO_GEOM_METADATA (a view of ALL_SDO_GEOM_METADATA) with the correct metadata.