Statements (32)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:database
|
| gptkbp:allows |
restoring table to previous state
|
| gptkbp:benefit |
minimizes downtime
no need for point-in-time recovery quick recovery from logical errors |
| gptkbp:canBe |
DBA
user with FLASHBACK privilege |
| gptkbp:cannotBeUsedIf |
table has been altered with certain DDL changes
table has been dropped table has been moved to another tablespace table has been re-created table has been truncated |
| gptkbp:commanded |
FLASHBACK TABLE
|
| gptkbp:doesNotRestore |
dropped columns
table structure changes |
| gptkbp:hasSyntax |
FLASHBACK TABLE table_name TO TIMESTAMP (timestamp);
FLASHBACK TABLE table_name TO SCN (scn_number); |
| gptkbp:introducedIn |
gptkb:Oracle_10g
|
| gptkbp:partOf |
gptkb:Oracle_Database
|
| gptkbp:relatedTo |
gptkb:Oracle_Flashback_Database
gptkb:Oracle_Flashback_Query gptkb:Oracle_Flashback_Transaction_Query Oracle Flashback Drop |
| gptkbp:requires |
row movement enabled
sufficient undo retention |
| gptkbp:restored |
table data
table indexes table constraints |
| gptkbp:uses |
undo data
|
| gptkbp:bfsParent |
gptkb:Oracle_Database_18c
|
| gptkbp:bfsLayer |
8
|
| https://www.w3.org/2000/01/rdf-schema#label |
Oracle Flashback Table
|