Oracle 删除大表数据

 

 create table test_temp as select * from test t where t.add_data >= '20100817000000';

 

 create table temp as select * from T1 where ......

drop table t1 

alter table temp rename t1;