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 |