RENAME TABLE statement The RENAME TABLE statement renames an existing table in any schema (except the schema SYS). RENAME TABLE statementSQL statementsRENAME TABLEtablesrenaming

To rename a table, you must be either the database owner or the table owner.

Syntax RENAME TABLE tableName TO newTableName

If there is a view 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.

 Example RENAME TABLE SAMP.EMP_ACT TO EMPLOYEE_ACT

See for more information.
Statement dependency system

The RENAME TABLE statement is not allowed if there are any open cursors that reference the table that is being altered.