Oracle SQL: the Essential Reference

RENAME

RENAME oldname TO newname

Changes the name of an existing table, view, sequence, or private synonym.

Integrity constraints, indexes, and grants on the old object are automatically transferred to the new object.

Keywords

oldname

Specifies the name of the existing object for which you want to assign a new name.

newname

Specifies the new name for the database object.

Objects that depend on the renamed object (e.g., views, synonyms, stored procedures, or functions) will be marked invalid.

Example

Change the name of the emp table to employees:

RENAME emp TO employees;