Oracle Flashback Technology

Submitted by UMBRO
on September 6, 2007 - 5:02am

Features:

Oracle Flashback Query
Oracle Flashback Version Query
Oracle Flashback Transaction Query
Oracle Flashback Table
Oracle Flashback Drop
Oracle Flashback Database

Flashback Table, Flashback Query, Flashback Transaction Query and Flashback Version Query all rely on undo data, records of the effects of each update to an Oracle database and values overwritten in the update. Used primarily for such purposes as providing read consistency for SQL queries and rolling back transactions, these undo records contain the information required to reconstruct data as it stood at a past time and examine the record of changes since that past time.

Oracle Flashback Drop entails Recycle Bin.

Oracle Flashback Database entails flash recovery area and ARCHIVELOG mode.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.