There are two ways of renaming a table in Oracle:
Method 1: Simple
rename {old_table_name} to {new_table_name}
Example:
rename CUSTOMER to CUSTOMER_BACKUP
Method 2: Not so Complex
alter table {old_table_name} rename to {new_table_name};
Example:
alter table CUSTOMER rename to CUSTOMER_BACKUP;
The minimum version that supports table renaming is Oracle 8i. All the dependencies of the table will automatically updated. No need of updating them after wards.
