If you wish to rename a table, you may have to remember some obstacles here. For instance, you are not allowed to rename somebody else’s table using their schema.table name even if you have access to this table. Oracle won’t allow it during the SQL parse phase. See below
So the right way to rename table in somebody else schema would be ALTER TABLE statement
alter table hr.employees rename new_employees;
Keep in mind, you must have access to hr.employees object if you are working as oe user now.
You can simply rename tables like that even if they are in different schemas. You just need to grant access to the requestor.
rename employees to new_employees;
rename new_employees to employees;
One thought on “RENAME a table”
Hey there! I’ve been reading your blog for a long time now and finally got the courage to go ahead and give you a shout
out from Dallas Texas! Just wanted to mention keep up the excellent work!