I face wiht this issue when I try to rename table or index name on standalone 11.2.0.1 database with ASM on AIX operating system:

Symptoms:

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 raise when I put schema name in front of the last_tablename.

SQL> alter table hr.[prev_tablename] rename to hr.[last_tablename] >>>  Its give ORA-14047

Solution:

SQL> alter table hr.[prev_tablename] rename to [lasttable_name]

 

Advertisements