完整的闪回操作

①闪回到临时表

create table t_spare_part_temp as select * from t_spare_part as of timestamp to_timestamp('2011-7-16 17:40:03','yyyy-mm-ddhh24:mi:ss');

 

②删除原表

delete from t_spare_part;

 

③把临时表数据恢复到原表

insert into t_spare_part select * from t_spare_part_temp;