ORA-29845: indextype does not support local domain index on list partitioned table (Doc ID 2391925.1)

Last updated on APRIL 08, 2022

Applies to:

Symptoms

Creating a spatial index on a list partitioned table fails with:

ORA-29845: indextype does not support local domain index on a list partitioned table

example:

CREATE TABLE SPATIAL_PART_TEST
(
ID NUMBER(15) NOT NULL,
LOG_PKEY INT NOT NULL,
GEOMETRY MDSYS.SDO_GEOMETRY,
GEO_TYPE VARCHAR2(30) DEFAULT 'POLYGON' NOT NULL,
GEO_PART_KEY NUMBER(2) NOT NULL,
DATE_CREATED DATE DEFAULT SYSDATE NOT NULL
)
PARTITION BY LIST (LOG_PKEY,GEO_PART_KEY)
(
PARTITION SPT_1_01 VALUES (1,1),
PARTITION SPT_1_02 VALUES (1,2),
PARTITION SPT_1_03 VALUES (1,3)
)
/

CREATE INDEX SPT_GEOM_IDX ON SPATIAL_PART_TEST (GEOMETRY)
INDEXTYPE IS MDSYS.SPATIAL_INDEX LOCAL
PARAMETERS ('SDO_INDX_DIMS=2 SDO_RTR_PCTFREE=10 SDO_FANOUT=40 SDO_COMMIT_INTERVAL=512');
/
ERROR at line 2:

ORA-29845: indextype does not support local domain index on list partitioned table

Changes

Cause

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