Oracle Rename Table
The RazorSQL alter table tool includes a Rename Table option for renaming an Oracle database table. The rename table option allows the user to type in a new name for the table being renamed. The tool then generates and can execute the SQL to rename the Oracle database table.
Listed below is an example of the SQL generated by the Oracle Rename Table function:
ALTER TABLE TESTUSER.EMPLOYEE RENAME TO EMPLOYEE_2
Below is a screen shot of the rename table function of the Oracle alter table tool.