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_CHAINSdisplays system chain information for all blockchain tables in the database. -
USER_BLOCKCHAIN_TABLE_CHAINSdisplays system chain information for the blockchain tables owned by the current user. This view does not display theSCHEMA_NAMEcolumn.
| 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 |
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 AI Database 26ai.
See Also: