Oracle Backup & Recovery Techniques - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 336

Flashback Transaction Query
Flashback Transaction Query is basically querying the
FLASHBACK_TRANSACTION_QUERY view. This view not
only provides the information regarding the transaction but also
provides the SQL statement to undo the transaction.
Like Flashback query, make sure that the database is running
under Automatic Undo Management and you have set the
UNDO_RETENTION initialization parameter. Moreover, set the
undo tablespace with RETENTION GUARANTEE option, this
will make sure nothing gets over written in case undo tablespace
gets full before UNDO_RETENTION period.
SELECT operation, undo_sql, logon_user
FROM flashback_transaction_query
WHERE xid = HEXTORAW('0A0009005F060000');
This query helps you to get the undo SQL for the
VERSIONS_XID that you retrieved using Flashback Version
Query.
Things to Remember Before Moving Ahead
1) Figure 10-1: Oracle 10g backup and recovery
techniques can be divided into 5 major categories: User
Managed, RMAN based, Enterprise Manager Database
Control based, Logical and Flashback Technology
based.