Spatial Index Creation Fails with ORA-13203: failed to read USER_SDO_GEOM_METADATA view (Doc ID 1558060.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Spatial and Graph - Version 10.2.0.3 and later
Oracle Multimedia - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.
***** Checked for Relevance on 02-Mar-2015 *****

Symptoms

 Spatial index creation is failing with following message:

SQL> CREATE INDEX EGISWEST.ASSET_GPS_LOCATION_SPT_IDX ON EGISWEST.ASSET_GPS_LOCATION
(GPS_LOCATION)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS('layer_gtype=point')
NOPARALLEL;
2    3    4    5  CREATE INDEX EGISWEST.ASSET_GPS_LOCATION_SPT_IDX ON EGISWEST.ASSET_GPS_LOCATION
*
ERROR at line 1:
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms