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:
Oracle Spatial and Graph - Version 12.2.0.1 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |