ORA-13203 Error When Creating Spatial Index (Doc ID 1437096.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 10.1.0.3 to 11.2.0.3 [Release 10.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 30-Jun-2015***

Symptoms

While creating a spatial index, it fails with the error:

CREATE INDEX geoData_idx
ON geouser.geoData(shape)
INDEXTYPE IS MDSYS.SPATIAL_INDEX; 2 3
CREATE INDEX geoData_idx
*
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