ALL_IMMUTABLE_ROW_VERSION_HISTORY
ALL_IMMUTABLE_ROW_VERSION_HISTORY provides a history of row versions in the immutable tables accessible to the current user.
This view is populated for an immutable table with a row version only when rows are purged from that immutable table. For each different value of the PDB_GUID and KEYCOLn_VALUE columns, information about only the youngest purged row is kept in the view.
Related Views
-
DBA_IMMUTABLE_ROW_VERSION_HISTORYprovides a history of row versions in all immutable tables in the database. -
USER_IMMUTABLE_ROW_VERSION_HISTORYprovides a history of row versions in the immutable tables owned by the current user. This view does not display theSCHEMA_NAMEcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SCHEMA_NAME |
VARCHAR2(128) |
NOT NULL |
Schema containing the immutable table |
TABLE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the immutable table |
ROW_VERSION_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the row version |
PDB_GUID |
RAW(16) |
Global unique identifier of the pluggable database that inserted the row before any GoldenGate processes might have replicated the row to another database | |
KEYCOL1_VALUE |
VARCHAR2(400) |
Value of version key column 1 | |
KEYCOL2_VALUE |
VARCHAR2(400) |
Value of version key column 2 Null if only one version key column is specified for the row version |
|
KEYCOL3_VALUE |
VARCHAR2(400) |
Value of version key column 3 Null if only one or two version key columns are specified for the row version |
|
VERSION_NUMBER |
NUMBER |
Row version number | |
ROW_CREATE_TIME |
TIMESTAMP(6) WITH TIME ZONE |
Date and time at which the row version was created | |
INST_ID |
NUMBER |
Identifier of any instance using a distributed or XA transaction to append to the row version history | |
TRAN_ID |
VARCHAR2(22) |
Identifier of any distributed transaction branch that is appending to the row version history |
Note: This view is available starting with Oracle AI Database 26ai.