ORA-29886 Error For Spatial Index V2? (Doc ID 2900029.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

Getting the error ORA-29886: feature not supported for domain indexes when creating spatial index

CREATE TABLE <owner>.<table>
("SYS_ID" NUMBER(10,0) NOT NULL ENABLE,
 ....<more columns>,

GEOMETRY SDO_GEOMETRY
)
 VARRAY GEOMETRY.SDO_ELEM_INFO STORE AS SECUREFILE LOB
  (ENABLE STORAGE IN ROW CHUNK 8192
  CACHE NOCOMPRESS KEEP_DUPLICATES)
 VARRAY GEOMETRY.SDO_ORDINATES STORE AS SECUREFILE LOB
  (ENABLE STORAGE IN ROW CHUNK 8192
  CACHE NOCOMPRESS KEEP_DUPLICATES)
PARTITION BY LIST (<column>) AUTOMATIC
SUBPARTITION BY LIST (<column>)
SUBPARTITION TEMPLATE
(SUBPARTITION <column> VALUES (NULL) TABLESPACE USERS,
 SUBPARTITION <column> VALUES (DEFAULT) TABLESPACE USERS)
(partition def_part values ('NULL'))
enable row movement;
 
CREATE INDEX <owner>.<index> ON <owner>.<table> (GEOMETRY) INDEXTYPE IS "MDSYS"."SPATIAL_INDEX_V2" PARAMETERS ('tablespace= USERS') LOCAL;
CREATE INDEX ....
  *
ERROR at line 1:
ORA-29886: feature not supported for domain indexes

Solution

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