Rename Command fails with ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations

advertisements

_____________________________________________________________________________________________________________________

Error Description

Table rename command fails with following error.

SQL> alter table scott.test rename to scott.tst;

alter table scott.test rename to scott.tst

                                          *

ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations

Solution Description

The table rename syntax is

Alter table <table name> rename to <new table name>;

Or

Rename <table name> to < new table name >;

But if you qualify the new table name with the schema, you will get the above error. You should use the following syntaxes. See some examples

SQL> create table test (name varchar2(10));

Table created.

SQL>  alter table scott.test rename to tst;

Table altered.

OR

SQL> rename test to tst;

Table renamed.

OR

SQL> alter table test  rename to tst;

Table altered.

_____________________________________________________________________________________________________________________

Website Stats