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

Have your ever tried to rename an Oracle table or index and got this error: ORA-14047?

According to Oracle’s docs, the following is the syntax of changing a table or index name:

ALTER TABLE [schema.]table_name RENAME TO <new_table_name>;

ALTER INDEX [schema.]index_name RENAME TO <new_index_name>;

Note the new table/index name should NOT have the schema name in front of it. If you don’t notice this detail as I didn’t and add the shcema name for the new name, you will get the ORA-14047 error.

Leave a Reply

Fill in your details below or click an icon to log in:

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 )

Connecting to %s