Skip to content

How to Resolve ORA-14133: ALTER TABLE MOVE cannot be combined with other operations

  • by

ORA-14133

Tried to move a table to another tablespace, but it failed with ORA-14133.

SQL> alter table employees move erp_tbs;
alter table employees move erp_tbs
                           *
ERROR at line 1:
ORA-14133: ALTER TABLE MOVE cannot be combined with other operations

ORA-14133 means that a right keyword is expected in ALTER TABLE MOVE statement, it could be TABLESPACE, ONLINE, LOGGING, NOLOGGING, etc.

In the above case, you missed the keyword TABLESPACE where the error pointed out.

Let's see another case.

SQL> alter table employees move tablespace erp_tbs nowait;
alter table employees move tablespace erp_tbs nowait
                                              *
ERROR at line 1:
ORA-14133: ALTER TABLE MOVE cannot be combined with other operations

NOWAIT is a keyword, but it's not supposed to be there.

Solution

To solve ORA-14133, we should use the correct syntax to move the table.

SQL> alter table employees move tablespace erp_tbs online;

Table altered.

We have moved the table.

Leave a Reply

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