Flashback Query

GPTKB entity

Statements (21)
Predicate Object
gptkbp:instanceOf gptkb:database
gptkbp:allows querying past data
gptkbp:cannotRecover dropped tables (use Flashback Drop)
purged data
gptkbp:developedBy gptkb:Oracle_Corporation
gptkbp:documentation https://docs.oracle.com/en/database/oracle/oracle-database/19/adfns/flashback-query.html
gptkbp:enables AS OF queries
point-in-time queries
gptkbp:hasSyntax SELECT * FROM table AS OF TIMESTAMP ...
https://www.w3.org/2000/01/rdf-schema#label Flashback Query
gptkbp:introducedIn gptkb:Oracle_9i
gptkbp:relatedTo gptkb:Flashback_Database
gptkb:Flashback_Drop
gptkb:Flashback_Table
gptkbp:requires sufficient UNDO retention
gptkbp:usedFor data recovery
auditing changes
gptkbp:usedIn gptkb:Oracle_Database
gptkbp:uses gptkb:UNDO_data
gptkbp:bfsParent gptkb:Oracle_Flashback_Technology
gptkbp:bfsLayer 7