ORA-13011: value is out of range During Create a Spatial Index.

Hi,

Sometimes you can get  “ORA-13011: value is out of range ” error during create a spatial index.

Details of error are as follows.

ORA-13011: value is out of range

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13200: internal error [ROWID:AAAFXYAADAAABxyAAD] in spatial indexing.
ORA-13206: internal error [] while creating the spatial index
ORA-13011: value is out of range
ORA-00600: internal error code, arguments: [kope2upic014], [], [], [], [],

You should increase the spatial extent / bounding box of the table in user_sdo_geom_metadata as follows.

e.g.


from


INSERT INTO USER_SDO_GEOM_METADATA VALUES (
'REGULATEDUSE',
'SHAPE1',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('Longitude', 0, 200000, .05),
MDSYS.SDO_DIM_ELEMENT('Latitude', 0, 500000, .05)
),
32614
);

to

delete USER_SDO_GEOM_METADATA where table_name='REGULATEDUSE' and column_name='SHAPE1';

INSERT INTO USER_SDO_GEOM_METADATA VALUES (
'REGULATEDUSE',
'SHAPE1',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('Longitude', 0, 4000000, .05),
MDSYS.SDO_DIM_ELEMENT('Latitude', 0, 9000000, .05)
),
32614
);
commit;

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/