Encounter Ora-14047:alter table| INDEX RENAME May is combined with other operations error
[[email protected] ~]$ sqlplus lc0029999/aaaaaasql*plus:release 11.2.0.4.0 Production on Wed June 00:11:32 2015Copyright (c) 1982,-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 on line 1:ora-14047:alter table| INDEX RENAME May is combined with and operationssql> ALTER TABLE T1 RENAME to lc0039999.tt1;alter table T1 Renam E to Lc0039999.tt1 *error on line 1:ora-14047:alter table| INDEX RENAME may isn't combined with and operationssql> show Useruser is "LC0029999" sql>
Query MoS to get the following article: Ora-14047:alter TABLE | INDEX RENAME May is Combined with other Operations (document ID 400398.1)
In this article, the reasons for the error are explained:
The combination of actions appear to be:1.the actual table rename2.specifiying the schema name of the target
In other words, do not bring the schema of the target table
It is worth noting that even under the same schema, the target table with the same schema name is not allowed, as follows:
Sql> show Useruser is ' LC0029999 ' sql> alter TABLE lc0029999.t1 Rename to Lc0029999.tt1; ALTER TABLE LC0029999.T1 Rename to Lc0029999.tt1
But the source table can take schema information, as follows:
Sql>
Encountered Ora-14047:alter table| INDEX RENAME May is combined with other operations error