flashback scripts

FLASHBACK TABLE t1
TO TIMESTAMP (SYSDATE - 5);

FLASHBACK TABLE x to before drop;
FLASHBACK TABLE persons TO TIMESTAMP TO_TIMESTAMP
('2005-04-05 10:00:00', 'YYYY-MM-DD HH24:MI:SS');


SELECT * FROM "BIN$xTMPjHZ6SG+1xnDIaR9E+g==$0";

DROP TABLE test PURGE;


select * from temp as of timestamp to_timestamp('2008-04-04 10:52:00','YYYY-MM-DD HH:MI:SS')

select versions_starttime, versions_endtime, versions_xid, versions_operation
from t1 versions between timestamp minvalue and maxvalue
order by VERSIONS_STARTTIME


SELECT xid, operation, start_scn,commit_scn, logon_user, undo_sql
FROM flashback_transaction_query
WHERE xid = HEXTORAW('0024002F0005766E');


SELECT versions_xid
, versions_startscn
, versions_endscn
, DECODE( versions_operation
, 'I', 'Insert'
, 'U', 'Update'
, 'D', 'Delete'
, 'Original'
) "Operation"
FROM t1
VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE
/




SELECT versions_startscn, versions_starttime,
versions_endscn, versions_endtime,
versions_xid, versions_operation
FROM t1 VERSIONS BETWEEN TIMESTAMP
TO_TIMESTAMP('2008-05-24 13:00:00', 'YYYY-MM-DD HH24:MI:SS')
AND TO_TIMESTAMP('2008-05-24 14:35:00', 'YYYY-MM-DD HH24:MI:SS')