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 AUGUST 10, 2020

Applies to:

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

Goal

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?


 

Solution

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
Goal
Solution
References


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