| General Information |
| Library Note |
Morgan's Library Page Header
|
| |
| Flashback Technology |
Scenario Examples |
Uses |
Affects Data |
| Database |
Truncate table or undesired changes made by DDL or DML |
Flashback Logs |
True |
| Drop |
Drop Table |
Recyclebin |
True |
| Query |
Compare current and past data or data from different points-in-time |
Undo Data / Flashback Archive |
False |
| Table |
Update with the wrong or no WHERE clause |
Undo Data / Flashback Archive |
True |
| Temporal Validity |
Query rows based upon their valid date range |
Hidden Table Columns |
False |
| Transaction Backout |
Reverse transaction(s) with/without cascade (DBMS_FLASHBACK) |
Undo Data / Flashback Archive |
True |
| Transaction Query |
Investigate one or more historical states of data |
Undo Data / Flashback Archive |
False |
| Version Query |
Compare versions of a row |
Undo Data / Flashback Archive |
False |