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 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.
