FLASCHBACK DATABASE
- ARCHIVELOG mode- Flashback Logs
- Flash Recovery Area
- SYSDBA privilege
- Database mount mode
FLASHBACK QUERY
- UNDO
FLASHBACK TABLE
- UNDO
- Row movement must be enabled
Flashback Version Query
- UNDO
Flashback Transaction Query
- UNDO
- SUPPLEMENTAL LOG
- SUPPLEMENTAL LOG PRIMARY KEY
- 10.0 compatibility
FLASCHBACK DROP
- Recycle Bin
FLASHBACK ARCHIVE
- Automatic Undo Management
- Automatic segment space management on table space
| Database level | Data will be modified ? | Technology |
|---|---|---|
| Database | Yes (uses flashback logs and archived logs) | Flashback logs |
| Table | Yes | Undo |
| Drop Table | Yes (obviously you accidentally dropped the table) | Recycle Bin |
| Query | No | Undo |
| Version Query | No | Undo |
| Transaction Query | No | Undo |
| Archive | Yes | Flashback Data Archive |
Kaynaklar :
Etiketler :
Oracle