oracle数据库表数据恢复

select timestamp_to_scn(to_timestamp(‘2015-05-12 12:40:00‘,‘YYYY-MM-DD hh24:MI:SS‘)) from dual;

select dbms_flashback.get_system_change_number from dual;

select o.* from (
select * from orders as of scn 107080891
) o left join users u
on o.userpk = u.pk
where u.uniqueid = ‘ls13523105066@126.com‘

oracle数据库表数据恢复

原文：http://my.oschina.net/soonlive/blog/413821