Several ways to modify the table name in oracle, and several ways to modify the table in oracle

Several ways to modify the table name in oracle, and several ways to modify the table in oracle

Answer1:

Alter table old_table_name rename to new_table_name; (uppercase: System Command)

Answer2:

SQL> select tname from tab;
TNAME
------------------------------
TEST

SQL> rename test to temp;
Table renamed.

SQL> select tname from tab;
TNAME
------------------------------
TEMP
Rename can only modify tables under its schema.

Answer3:

Create new_table as select * from old_table; drop table old_table;

Answer4:

Directly change it in PLSQL Developer

Change table name in oracle

Rename test to test_new;

The name of a table is changed in ORACLE. Many views reference this table. Is there any way to change the table name in the view in batches?

If
After the old table name is changed to the new table name.
The original views that reference the old table name are invalid.

If the old table name is not used again.
Direct
Create public synonym old table name FOR new table name
Create a synonym.
The original view may not be modified.