快速回闪恢复drop，delete的表

1.drop

select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin t';-- 查看回收站中表

flashback table w to before drop;--恢复回收站的表

2.delete

select t.CURRENT_SCN from v$database t; --查出scn

select *from w as of scn 9959558; --查看scn数据是否删除的

insert into w select * from w as of scn 9959558; --恢复数据