一，查找大致时间点的SCN
select timestamp_to_scn(to_timestamp(‘2015-01-05 21:20:00‘,‘yyyy-mm-dd hh24:mi:ss‘)) from dual;
二，查询被删除的数据，并还原
insert into ERP_FACILITY_MAP select * from ERP_FACILITY_MAP as of scn 1603128909
select * from ERP_FACILITY_MAP
原文：http://blog.csdn.net/wuzfxx/article/details/42435267