oracle scn

-- 查询某个时间段的 SCN 系统快照号
select timestamp_to_scn(to_timestamp('2012-07-19 15:00:00','YYYY-MM-DD HH24:MI:SS')) from dual;
--根据系统快照号查询在该 SCN 号下 查询表对应的 数据集如
select * from text1(表名) as of scn 25107913(SCN号);
--通过 Insert into 语句还原表
insert into text1(表名) select * from select * from text1(表名) as of scn 25107913(SCN号);

select dbms_flashback.get_system_change_number from dual;