Creating Spatial index causing ORA-13364 layer dimensionality does not match geometry dimensions (Doc ID 1338644.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 29-October-2013***

Symptoms

Creating a Spatial index fails with below errors:

SQL> create table sdotest (geom sdo_geometry);

Table created.

SQL> insert into sdotest(geom) values(SDO_GEOMETRY(3002,NULL,NULL, SDO_ELEM_INFO_ARRAY(1,2,1), SDO_ORDINATE_ARRAY(3,3,0, 6,3,0, 6,5,0, 4,5,0)));

1 row created.

SQL> insert into user_sdo_geom_metadata(table_name, column_name, diminfo, srid) values ('sdotest', 'geom', mdsys.sdo_dim_array(mdsys.sdo_dim_element('X', 0, 20, 0.005), mdsys.sdo_dim_element('Y', 0, 20, 0.005)), NULL);

1 row created.

Create index failing with below error

SQL> CREATE INDEX sdotest_idx ON sdotest(GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX;
CREATE INDEX sdotest_idx ON sdotest(GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX
*
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-13249: Error in spatial index: [mdpridxtxfergm]
ORA-13200: internal error [ROWID:AAESw4AAPAAAg/jAAA] in spatial indexing.
ORA-13206: internal error [] while creating the spatial index
ORA-13364: layer dimensionality does not match geometry dimensions
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