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
Cause: A specified dimension value is outside the range defined for that dimension.
Action: Make sure that all values to be encoded are within the defined dimension 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/