oracle 修改表名几种方法

alter table byp3 rename to byp_2

rename byp_2 to byp3

create byp_2 as

select * from byp3

(在这里还可以给加个where限制条件直接取一个表格式或者取一部分数据就行)

drop byp3