遇到ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations错误
[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>
查询mos，，得到如下文章：ORA-14047: ALTER TABLE | INDEX RENAME May Not Be Combined With Other Operations (文档 ID 400398.1)在该文章中，说明了报错的原因：
The combination of actions appear to be:1.the actual table rename2.specifiying the schema name of the target
也就是说，不要带目标表的schema
值得注意的是，即使是在相同的一个schema下，目标表带有相同的schema名称，也是不允许的，如下：
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>
但是源表可以带schema信息，如下：
SQL> alter table lc0029999.t11 rename to tt1;Table altered.SQL>
人生没有彩排，每一天都是现场直播
