Oracle flashback transaction query

Using Oracle Flashback Transaction Query to retrieve metadada and historical data fro given transaction or for all transactions in a given time interval. Oracle Flashback Transaction Query queries the statis dictionary view FLASHBACK_TRANSACTION_QUERY
Enable flashback transaction query
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

Example:


SQL> delete from test;

5 rows deleted.

SQL> commit;

Commit complete.

SQL> insert into test (select * from test as of timestamp sysdate -1);

5 rows created.

SQL> commit;

Commit complete.