When we try to rename table or index name in Oracle, we use a simple command as following;
alter table [prev_table_name] rename to [last_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.
alter table hr.[prev_table_name] rename to hr.[last_table_name] >>> RAISES ORA-14047 ERROR alter table hr.[prev_table_name] rename to [last_table_name] >> CORRECT ONE
It is same with Index renaming.
It worked for me. Helpful post.
Thank you for solving my problem, I was getting so frustrated, I didn’t want to ask the users password