1. SCN(system change number 时间号)
select current_scn from v$database;
select * from 表名 as of scn 1499220;
flashback table 表名 to scn 1499220;
2. 时间戳
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
select * from 表名 as of timestamp to_timestamp('2013-05-29 15:29:00','yyyy-mm-dd hh24:mi:ss');
flashback table 表名 to timestamp to_timestamp('2013-05-29 15:29:00','yyyy-mm-dd hh24:mi:ss');