Strange error when renaming a table

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

When we try to rename a table or index name in Oracle, we use a simple command as following

ALTER TABLE [SCHEMA_NAME].[OLD_TABLE_NAME] RENAME TO [NEW_TABLE_NAME];

If we put into schema names to this command, we can deal with ORA-14047 error.
This error raise when we put schema name in front of the last_table_name.

ORA-14047: ALTER TABLE INDEX RENAME may not be combined with other operations
ALTER TABLE SCOTT.TABLE_NAME RENAME TO SCOTT.TABLE_NAME2;
ORA-14047: ALTER TABLE INDEX RENAME may not be combined with other operations
ALTER TABLE SCOTT.TABLE_NAME RENAME TO TABLE_NAME2;
Table altered.

It is same with Index renaming.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: