ORACLE表被删除后恢复

1.闪回到某个时间点前数据查询：
select * from yongqidizhi as of timestamp to_timestamp('2014-11-10 11:39:00','yyyy-mm-dd hh24:mi:ss');
--'2014-11-10 11:39:00' 这个时间是删除数据前的时间点
--检查核对查询出来的数据是否是丢失前的数据
2.将数据恢复到一个临时表，再次核对恢复的数据是否正确
insert into yongqidizhi_tmp (select * from yongqidizhi as of timestamp to_timestamp('2014-11-10 11:39:00','yyyy-mm-dd hh24:mi:ss'));
3.将临时表数据插入正式表
       insert into yongqidizhi (select * from yongqidizhi_tmp);