Several Ways of Modifying Table Names in oracle

answer1:

ALTER TABLE old_table_name RENAME TO new_table_name; (Capitalized as system commands)

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

answer3:

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

answer4:

Modify it directly in PLSQL Developer