Statements (33)
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); |
https://www.w3.org/2000/01/rdf-schema#label |
Oracle Flashback Table
|
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
gptkb:Oracle_Database_family |
gptkbp:bfsLayer |
8
|