6.4. Using Flashback Versions Query

The Flashback Versions Query is an improvement to the Flashback Query technology first developed in Oracle 9i. Flashback Versions Query allows you to retrieve all of the versions of the rows that exist or existed between the times the query was executed to a determined point-in-time in the past. The Flashback Versions Query returns all the committed occurrences of the rows for a query of an object, while not displaying the uncommitted row versions.

Flashback Versions Query works by retrieving data from the UNDO tablespace. The UNDO_RETENTION initialization parameter, which is specified in seconds, determines how much committed undo data to keep in the database. If transactions need additional undo space and ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.