Create Spatial Index Sdo_Indx_Dims=0 Gives ORA-13249 (Doc ID 362064.1)

Last updated on JULY 01, 2013

Applies to:

Oracle Spatial - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 01-Jul-2013***

Symptoms

Creating a Spatial index specifying SDO_INDX_DIMS  fails with errors:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13249: Error in spatial index: [mdrcrtxfergm]
ORA-13236: internal error in R-tree processing: [failed to allocate memory]
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10

A possible scenario is:

-- Create table statement :

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

-- Statement to insert metadata:

INSERT INTO USER_SDO_GEOM_METADATA
VALUES (
'cola_markets',
'shape',
MDSYS.SDO_DIM_ARRAY( -- 20X20 grid
MDSYS.SDO_DIM_ELEMENT('X', 0, 20, 0.005),
MDSYS.SDO_DIM_ELEMENT('Y', 0, 20, 0.005)),NULL );

-- Failing index creation statement :

CREATE INDEX cola_spatial_idx
ON cola_markets(shape)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS ('SDO_INDX_DIMS=0');
CREATE INDEX "SCOTT"."GEOM_IDX"

*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13249: Error in spatial index: [mdrcrtxfergm]
ORA-13236: internal error in R-tree processing: [failed to allocate memory]
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