| 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 point-in-time |
Undo
Data / Flashback Archive |
False |
| Table |
Update with the
wrong or no WHERE clause |
Undo
Data / Flashback Archive |
True |
| Transaction
Backout |
Reverse
transaction(s) with/without cascade (DBMS_FLASHBACK) |
Undo
Data / Flashback Archive |
True |
| Transaction
Query |
Investigate
several historical states of data |
Undo
Data / Flashback Archive |
False |
| Version
Query |
Compare
versions of a row |
Undo
Data / Flashback Archive |
False |
