alter table byp3 rename to byp_2
rename byp_2 to byp3
create byp_2 as
select * from byp3
(在这里还可以给加个where限制条件直接取一个表格式或者取一部分数据就行)
drop byp3
oracle 修改表名几种方法
原文：http://11504741.blog.51cto.com/11494741/1770653
