ORA-14427 While Trying To Alter partition table contains SDO_GEOMETRY column
(Doc ID 2581497.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
Partition table contains SDO_GEOMETRY column
When we try alter partition table it will thrown an error "ORA-14427: table does not support modification to a partitioned state DDL error when he tried to partition a table with Geospatial data with this statement"
Command executed as below
ALTER TABLE <TABLE_NAME> MODIFY
PARTITION BY RANGE(DATEREFERENCE) INTERVAL (NUMTODSINTERVAL(1,'DAY'))
PARTITION p0 VALUES LESS THAN (TO_DATE('01-JAN-2019','dd-MON-yyyy'))
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