Security privileges
To flash back or back-out a transaction—that is, to create a compensating transaction—you must have the SELECT, FLASHBACK, and DML privileges on all affected tables.
Conditions of Use
Transaction back-out is not supported across conflicting DDL.
Transaction back-out inherits data type support from LogMiner. See the Oracle Database 11g documentation for supported data types.
Recommendation
When you discover the need for transaction back-out, performance is better if you start the back-out operation sooner. Large redo logs and high transaction rates result in slower transaction back-out operations.
Provide a transaction name for the back-out operation to facilitate later auditing. If you do not provide a transaction name, it will be automatically generated for you.