Rename a table in Oracle

Oracle provides a rename table syntax as follows:

alter table
table_name
rename to
new_table_name;

For example, we could rename the customer table to old_customer with this syntax:

alter table
customer
rename to
old_customer;

When you rename an Oracle table you must be aware that Oracle does not update applications (HTML-DB, PL/SQL that referenced the old table name) and PL/SQL procedures may become invalid.