Creating a Spatial Index fails with ORA-29855, ORA-13249: Size too big (Doc ID 3051282.1)

Last updated on OCTOBER 02, 2024

Applies to:

Symptoms

On 19c, creating a Spatial index fails with the following error:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: Size too big
ORA-13249: Size too big
ORA-13249: Size too big
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10


Statement that fails:

CREATE INDEX <index_name> ON <table_name> (<column_name>)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.