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.

• Oracle