6.5. Using Flashback Transaction Query
The Flashback Transaction Query is designed to be a diagnostic tool to help identify changes made to the database at the transaction level. This tool can be used to perform analysis on data for audits of transactions. With Flashback Transaction Query, you can identify all changes made within a specific time period, as well as perform transactional recovery of tables.
The Flashback Transaction Query is based on undo data and utilizes the UNDO_RETENTION initialization parameter to determine the amount of time to retain committed undo data in the database. The Flashback Transaction Query also uses the RETENTION GUARANTEE in the same manner as the previously discussed Flashback Versions Query.
The Flashback ...
Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
