1.select timestamp_to_scn(to_timestamp('2016-02-23 10:00','YYYY-MM-DD HH24:MI:SS')) from dual
2.create table my_table_bak as select * from my_table as of scn 13627283657906
3.drop table my_table
4.rename my_table_bak to my_table
1、从flash back里查询被删除的表
select * from recyclebin
2.执行表的恢复
flashback table tb to before drop,这里的tb代表你要恢复的表的名称。
flashback table test to timestamp to_timestamp('2015-05-07 15:00:00','yyyy-mm-dd hh24:mi:ss');