For convenience, Oracle provide RENAME statement to change some types of object's name. The syntax is as:
There're only 4 types of schema object that can use RENAME TO statement.
- Private synonym
Examples can be found in the following posts:
- How to Rename Table in Oracle
- How to Rename View in Oracle
- How to Rename Sequence in Oracle
- How to Rename Synonym in Oracle
Please note that, you have to login as the object owner and don't qualify the object name with the schema name in RENAME TO statement.