Strange error when renaming a table

ORA-14047: ALTER TABLE INDEX RENAME may not be combined with other operations When we try to rename a table or index name in Oracle, we use a simple command as following If we put into schema names to this command, we can encounter ORA-14047 error.This error raises when we put schema name in front of the last_table_name. But, if we use: it will work! It is same with Index renaming.

Read More →