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:
You can also rename table name using following statement
ALTER TABLE old_table_name RENAME TO new_table_name;