You are currently browsing the tag archive for the ‘ORA-14047:’ tag.

I hit this issue while I was trying to rename table (or index) name on 11.2.0.4 database.

Symptoms is:

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

Solution:

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

 

Advertisements
Advertisements
Advertisements