Alter Table Move Results In "ORA-14427: Table Does Not Support Modification To A Partitioned State"
(Doc ID 2606040.1)
Last updated on AUGUST 10, 2020
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
I'm trying to move a table online but I'm getting this:
alter table TEST1.TESTTable move online tablespace TEST1 UPDATE INDEXES
ERROR at line 1:
ORA-14427: table does not support modification to a partitioned state DDL
I can move it successfully without the online:
SQL> alter table TEST1.TESTTable move tablespace TEST1_SHRINK UPDATE INDEXES;
The Table is not partitioned
What am I doing wrong?
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