Skip to content

Oracle RENAME Statement

  • by

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 *