To rename a view, we should RENAME TO statement to rename it, but you have to login as the object's owner. For example: SQL> show… Read More »How Oracle Rename View
RENAME Syntax For convenience, Oracle provide RENAME statement to change some types of object's name. The syntax is as: RENAME old_name TO new_name; There're only… Read More »Oracle RENAME Statement