SCN<=>TIMESTAMP

 select dbms_flashback.get_system_change_number from dual;

 

SCN =>TIMESTAMP:

select scn_to_timestamp(20110899) from dual;

 

TIMESTAMP=>SCN:

alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

select timestamp_to_scn(to_timestamp('2011-12-07 11.11:11','yyyy-mm-dd hh24:mi:ss')) scn from dual;

OR

select timestamp_to_scn(to_timestamp('&time','yyyy-mm-dd hh24:mi:ss')) scn from dual;

 

INSERT INTO RECOVERY_TABLE SELECT * FROM as of scn as of timestamp(to_timestamp('TIME','yyyy-mm-dd hh24:mi:ss'))

OR

as of timestamp(systemtimestampinterval'1440'second)