I hit this issue while I was trying to rename table (or index) name on 22.214.171.124 database.
I use a simple command as following;
alter table [prev_tablename] rename to [last_tablename]
If We put into schema names to this command, We can deal with ORA-14047 error.
The error raises when I put the schema name in front of the last_tablename.
SQL> alter table hr.[prev_tablename] rename to hr.[last_tablename] >>> Its give ORA-14047
SQL> alter table hr.[prev_tablename] rename to [lasttable_name]
Bir Cevap Yazın