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