Can We Rename a Table in Oracle

Use the RENAME statement to rename a table, view, sequence, or private synonym. Oracle Database automatically transfers integrity constraints, indexes, and grants on the old object to the new object.

Can you rename a table in Oracle?

Use the RENAME statement to rename a table, view, sequence, or private synonym. Oracle Database automatically transfers integrity constraints, indexes, and grants on the old object to the new object.

How do I change a table name in database?

Select the table you want to rename. Once the table is selected, click on the Operations tab. In the Table Options section, enter the new table name in the Rename table to textbox. Click Go to save the changes.