可以这样分步的拷入到另外一些结构相同的表中如: create table t001 as select * from TB where 条件1; create table t002 as select * from TB where 条件2; create table t003 as select * from TB where 条件3; ... 然后再插入表中另一表备份中(bak)insert into bak select * from t001; insert into bak select * from t001; insert into bak select * from t001; ...另外一种,可以用导入imp和导出exp这个表试试
create table t001 as select * from TB where 条件1;
create table t002 as select * from TB where 条件2;
create table t003 as select * from TB where 条件3;
...
然后再插入表中另一表备份中(bak)insert into bak select * from t001;
insert into bak select * from t001;
insert into bak select * from t001;
...另外一种,可以用导入imp和导出exp这个表试试