RENAME TABLE allows you to rename an existing table in any schema (except the schema SYS).
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.
Also
see
If there is an index defined on the table, the table can be renamed.
RENAME TABLE is not allowed if there are any open cursors that reference the table being altered.