My Oracle Support Banner

Alter Table Move Results In "ORA-14427: Table Does Not Support Modification To A Partitioned State" (Doc ID 2606040.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


I'm trying to move a table online but I'm getting this:

SQL> alter table TEST1.TESTTable move online tablespace TEST1_SHRINK UPDATE INDEXES;
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;

Table altered.

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

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