Skip to content
Home » Oracle Database » Oracle RENAME Statement

Oracle RENAME Statement

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 4 types of schema object that can use RENAME TO statement.

  • Table
  • View
  • Sequence
  • Private synonym

Examples can be found in the following posts:

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.

Leave a Reply

Your email address will not be published. Required fields are marked *