Oracle删除大表数据

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;