English

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

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.