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

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.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google