ALL_BLOCKCHAIN_ROW_VERSION_HISTORY

ALL_BLOCKCHAIN_ROW_VERSION_HISTORY provides a history of row versions in the blockchain tables accessible to the current user.

This view is populated for a blockchain table with a row version only when rows are purged from that blockchain 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.

Column Datatype NULL Description
SCHEMA_NAME VARCHAR2(128) NOT NULL Schema containing the blockchain table
TABLE_NAME VARCHAR2(128) NOT NULL Name of the blockchain 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 associated with version key column 1
KEYCOL2_VALUE VARCHAR2(400)  

Value associated with version key column 2

Null if only one version key column is specified for the row version
KEYCOL3_VALUE VARCHAR2(400)  

Value associated with 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
USER_CHAIN_HASH RAW(2000)   User chain cryptographic hash
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.

See Also: