Flashback Transaction Query

GPTKB entity

Statements (41)
Predicate Object
gptkbp:instanceOf Oracle Database Feature
gptkbp:accessibleBy SELECT * FROM FLASHBACK_TRANSACTION_QUERY
gptkbp:canBe gptkb:Application_Developer
DBA
Auditor
gptkbp:columnistFor gptkb:CSF
gptkb:OPERATION
gptkb:REDO_SQL
gptkb:XID
COMMIT_SCN
LOGON_USER
ROW_ID
START_SCN
TABLE_NAME
TABLE_OWNER
UNDO_CHANGE#
UNDO_SQL
gptkbp:compatibleWith gptkb:Oracle_Standard_Edition
gptkbp:documentedIn gptkb:Oracle_Database_Documentation
gptkbp:enables Auditing data changes
Identifying undo SQL for transactions
Recovering from logical data corruption
Viewing committed and rolled back transactions
https://www.w3.org/2000/01/rdf-schema#label Flashback Transaction Query
gptkbp:introducedIn gptkb:Oracle_Database_10g_Release_2
gptkbp:partOf gptkb:Oracle_Flashback_Technology
gptkbp:relatedTo gptkb:Oracle_Database
gptkb:Flashback_Drop
gptkb:Flashback_Query
gptkb:Flashback_Table
gptkbp:requires gptkb:UNDO_tablespace
Database in ARCHIVELOG mode
Sufficient UNDO retention
Supplemental logging
gptkbp:supportedBy gptkb:Oracle_Enterprise_Edition
gptkbp:usedFor Undoing specific transactions
Viewing changes made by a transaction
gptkbp:uses gptkb:FLASHBACK_TRANSACTION_QUERY_view
gptkb:Oracle_Data_Dictionary_Views
gptkbp:bfsParent gptkb:Oracle_Flashback_Technology
gptkbp:bfsLayer 7