oracle中修改表名的几种方式

answer1:

alter table old_table_name rename to new_table_name;(大写为系统命令)

answer2:

sql> select tname from tab ;
tname
------------------------------
test

sql> rename test to temp ;
table renamed.

sql> select tname from tab ;
tname
------------------------------
temp
rename只能修改自己schema下面的表。

answer3:

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

answer4:

直接在plsql developer里面改