Oracle: Rename Table

Oracle rename table syntax

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.