Creating a Spatial Index Fails with ORA-13203, ORA-13003 (Doc ID 1305758.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Getting following error with a simple spatial index creation -

SQL> CREATE TABLE cola_markets (
 mkt_id NUMBER PRIMARY KEY,
 name VARCHAR2(32),
 shape MDSYS.SDO_GEOMETRY);

Table created.

SQL> INSERT INTO USER_SDO_GEOM_METADATA
VALUES (
'cola_markets',
'shape',
MDSYS.SDO_DIM_ARRAY( -- 20X20 grid
MDSYS.SDO_DIM_ELEMENT('X', 20, 0, 0.005),
MDSYS.SDO_DIM_ELEMENT('Y', 20, 0, 0.005)
),
NULL -- SRID this is our own Coordinate System.
);

1 row created.

SQL> commit;

Commit complete.

SQL> CREATE INDEX cola_spatial_idx
ON cola_markets(shape)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;
CREATE INDEX cola_spatial_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-13003: the specified range for a dimension is invalid
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10


The same syntax  was working fine prior upgrading to 11.2.0.2 release.

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