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.