Shulou(Shulou.com)06/01 Report--

Error

SYS@orcl > alter table test rename to sys.test_bak

Alter table test rename to sys.test_bak

*

ERROR at line 1:

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

To do this, do not have a schema with the target table

SYS@orcl > alter table test rename to test_bak

Table altered.

Reason

The operation is regarded as a combined operation as indicated by the full error message description:

$oerr ora 14047

14047, 00000, "ALTER TABLE | INDEX RENAME may not be combined with other operations"

/ / Cause: ALTER TABLE or ALTER INDEX statement attempted to combine

/ / a RENAME operation with some other operation which is illegal

/ / Action: Ensure that RENAME operation is the sole operation specified in

/ / ALTER TABLE or ALTER INDEX statement

The combination of actions appear to be:

The actual table rename

Specifiying the schema name of the target

Document number

ORA-14047: ALTER TABLE | INDEX RENAME May Not Be Combined With Other Operations (document ID 400398.1)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.