Encountered ORA-14047: alter table | index rename may not be combined with other operations error, altertablerename
Encountered ORA-14047: alter table | index rename may not be combined with other operations Error
[oracle@rhel63single ~]$ sqlplus lc0029999/aaaaaaSQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 10 00:11:32 2015Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter table lc0039999.t1 rename to lc0039999.tt1;alter table lc0039999.t1 rename to lc0039999.tt1 *ERROR at line 1:ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operationsSQL> alter table t1 rename to lc0039999.tt1;alter table t1 rename to lc0039999.tt1 *ERROR at line 1:ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operationsSQL> show userUSER is "LC0029999"SQL>
Query mos and get the following article: ORA-14047: alter table | index rename May Not Be Combined With Other Operations (Document ID 400398.1)
The cause of the error is described in this article:
The combination of actions appear to be:1.the actual table rename2.specifiying the schema name of the target
That is to say, do not include the schema of the target table.
It is worth noting that, even in the same schema, the target strap has the same schema name, which is not allowed, as shown below:
SQL> show userUSER is "LC0029999"SQL> alter table lc0029999.t1 rename to lc0029999.tt1; alter table lc0029999.t1 rename to lc0029999.tt1 *ERROR at line 1:ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operationsSQL>
However, the source table can contain schema information as follows:
SQL> alter table lc0029999.t11 rename to tt1;Table altered.SQL>