ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operatio
I was trying to rename a table A.a_name to A.b_name . I am using the following DDL.
Alter table A.b_name rename to A.b_name ; --this statement fails.
This statement is giving me an error.
ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations
But when I drop the schemaname in the to-be-renamed tablename this works.
Alter table A.b_name rename to b_name ; --This statement is a success anb the tablename is altered.
I am running thiis DDL from the schema A. What is the difference between the DDLsusing the schema name and the one without the schemaname. What would the first DDL fails. Help!!