ALL_BLOCKCHAIN_ROW_VERSION

3.120 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.

Related Views

DBA_BLOCKCHAIN_ROW_VERSION_HISTORY provides a history of row versions in all blockchain tables in the database.
USER_BLOCKCHAIN_ROW_VERSION_HISTORY provides a history of row versions in the blockchain tables owned by the current user. This view does not display the SCHEMA_NAME column.

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 Database 23ai.