RENAME TABLE allows you to rename an existing table in any schema (except the schema SYS).
To rename a table, you must either be the database owner or the table owner.
RENAME TABLE table-Name TO new-Table-Name
If there is a view or foreign key that references the table, attempts to rename it will generate an error. In addition, if there are any check constraints or triggers on the table, attempts to rename it will also generate an error.
RENAME TABLE SAMP.EMP_ACT TO EMPLOYEE_ACT
See ALTER TABLE statement for more information.
The RENAME TABLE statement is not allowed if there are any open cursors that reference the table that is being altered.