DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.FLASHBACK_TRANSACTION_QUERY

Object Details
Object Name: FLASHBACK_TRANSACTION_QUERY
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of the flashback transaction query view

[View Source]

Columns
Name Datatype Length Mandatory Comments
XID RAW (8)
Transaction identifier
START_SCN NUMBER

Transaction start SCN
START_TIMESTAMP DATE

Transaction start timestamp
COMMIT_SCN NUMBER

Transaction commit SCN
COMMIT_TIMESTAMP DATE

Transaction commit timestamp
LOGON_USER VARCHAR2 (30)
Logon user for transaction
UNDO_CHANGE# NUMBER

1-based undo change number
OPERATION VARCHAR2 (32)
forward operation for this undo
TABLE_NAME VARCHAR2 (256)
table name to which this undo applies
TABLE_OWNER VARCHAR2 (32)
owner of table to which this undo applies
ROW_ID VARCHAR2 (19)
rowid to which this undo applies
UNDO_SQL VARCHAR2 (4000)
SQL corresponding to this undo
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT XID
,      START_SCN
,      START_TIMESTAMP
,      COMMIT_SCN
,      COMMIT_TIMESTAMP
,      LOGON_USER
,      UNDO_CHANGE#
,      OPERATION
,      TABLE_NAME
,      TABLE_OWNER
,      ROW_ID
,      UNDO_SQL
FROM SYS.FLASHBACK_TRANSACTION_QUERY;

Dependencies

[top of page]

SYS.FLASHBACK_TRANSACTION_QUERY references the following:

SYS.FLASHBACK_TRANSACTION_QUERY is referenced by following:

SchemaPUBLIC
SynonymFLASHBACK_TRANSACTION_QUERY