Encounter Ora-14047:alter table| INDEX RENAME May is combined with other operations error

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.