Oracle Flashback Table

GPTKB entity

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