oracle快速复制一个表

1.快速全量复制一张表

create table table_a_bak as select * from table_a;

2.筛选部分字段创建一张新表

create table table_a_bak as select id,name from table_a where id < 10000;

3.整合所需资源新建一张表

create table table_a_bak as select a.id,a.name,b.info from table_a a,tab_b b where a.id=b.aid;