Summary of the four ways to modify the Oracle table name, it is worth reference

Method One:

ALTER TABLE old_table_name RENAME to New_table_name; (Uppercase to System command)

Method Two:

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 the table below its own schema.

Method Three:

Create new_table as SELECT * from Old_table;drop table old_table;

method Four:

Directly inside the Plsql developer.

There are four ways to choose one that is right for you.