ERROR

ORA-29855: failed in the execution of the ODCIINDEXCREATE routine

Last Published: April 25, 2020

Error Message

If you are using Oracle Spatial 8.1.6 on a Unix server, create a table with a spatial column with 3 or 4 dimensions, and then create an r-tree spatial index on this table using the index creation parameter ‘SDO_INDX_DIMS = 2’. The following error is returned:

"ORA-29855: failed in the execution of the ODCIINDEXCREATE routine
ORA-13201: invalid parameters supplied in CREATE INDEX statement "

Cause

The parameter SDO_INDX_DIMS is not valid for creating a spatial index with Oracle 8.1.6. It is a new parameter for Oracle 8.1.7.

If you try to create an r-tree index on an Oracle Spatial table and the spatial column has more than two dimensions, the r-tree index will be unreliable when used for queries. This problem is addressed in Oracle 8.1.7 by the parameter SDO_INDX_DIMS. SDO_INDX_DIMS limits the number of dimensions indexed by the r-tree spatial index.

Solution or Workaround

For two-dimensional data, create an r-tree index by not specifying any index creation parameters.

Use a quad-tree index on three-dimensional or four-dimensional spatial columns when using Oracle 8.1.6.

    Article ID:000004489

    Software:
    • Legacy Products

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options