To rename a table, you use the following Oracle RENAME table statement as follows:
RENAME old_table_name TO new_table_name;
In the RENAME table statement:
- First, specify the name of the existing table which you want to rename.
- Second, specify the new table name. The new name must not be the same as another table in the same schema.
Points To Remember:
- you cannot roll back a RENAME statement once you executed it.
- When you rename a table, Oracle automatically transfers indexes, constraints, and grants on the old table to the new one.
- it invalidates all objects that depend on the renamed table such as views, stored procedures, function, and synonyms.
You can also rename table name using following statement
ALTER TABLE old_table_name
RENAME TO new_table_name;
