3.132 ALL_BLOCKCHAIN_TABLE_CHAINS

ALL_BLOCKCHAIN_TABLE_CHAINS displays system chain information for the blockchain tables accessible to the current user.

Related Views

  • DBA_BLOCKCHAIN_TABLE_CHAINS displays system chain information for all blockchain tables in the database.

  • USER_BLOCKCHAIN_TABLE_CHAINS displays system chain information for 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

Name of the schema containing the blockchain table

TABLE_NAME

VARCHAR2(128)

NOT NULL

Blockchain table name

PDB_GUID

RAW(16)

Global unique identifier of the pluggable database that can insert rows into the chain

INSTANCE_ID

NUMBER

NOT NULL

Identifier of the instance on the PDB that can insert rows into the chain

CHAIN_ID

NUMBER

NOT NULL

Chain ID number

By default, chains are numbered from 0 to 31.

EPOCH_NUMBER

NUMBER

Epoch number for this section of the chain

HASH_DATA_FMT_VER

NUMBER

Hash data format version for this section of the chain

MIN_SEQ_NUMBER

NUMBER

Smallest sequence number in this section of the chain

MAX_SEQ_NUMBER

NUMBER

Largest sequence number in this section of the chain

LAST_CREATE_TIME

TIMESTAMP(6) WITH TIME ZONE

 

Time at which the last row was added to this section of the chain

TRAN_ID

VARCHAR2(22)

 

Identifier of any distributed transaction that is appending a row to the chain

DELETED_SEQ_NUM

NUMBER

 

Largest sequence number for rows in the chain that have been deleted

DELETED_ROW_HASH

RAW(2000)

 

Cryptographic hash that was stored in the row of the chain with sequence number DELETED_SEQ_NUM

LAST_ROW_HASH

RAW(2000)

 

Cryptographic hash stored in the last row in this section of the chain with sequence number MAX_SEQ_NUMBER

Note:

This view is available starting with Oracle Database 23ai.