How to Resolve ORA-14511: cannot perform operation on a partitioned object

  • by

ORA-14511

There could be several kinds of error patterns that throws ORA-14511, this is one case.

Moving a Partitioned Table

SQL> alter table sh.sales move tablespace users;
alter table sh.sales move tablespace users
               *
ERROR at line 1:
ORA-14511: cannot perform operation on a partitioned object

This is because you cannot move such table like a normal one, you should move a partitioned table by some more deliberate steps.

Leave a Reply

Your email address will not be published. Required fields are marked *