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 theSCHEMA_NAME
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Name of the schema containing the blockchain table |
|
|
|
Blockchain table name |
|
|
|
Global unique identifier of the pluggable database that can insert rows into the chain |
|
|
|
Identifier of the instance on the PDB that can insert rows into the chain |
|
|
|
Chain ID number By default, chains are numbered from |
|
|
|
Epoch number for this section of the chain |
|
|
|
Hash data format version for this section of the chain |
|
|
|
Smallest sequence number in this section of the chain |
|
|
|
Largest sequence number in this section of the chain |
|
|
Time at which the last row was added to this section of the chain |
|
|
|
Identifier of any distributed transaction that is appending a row to the chain |
|
|
|
Largest sequence number for rows in the chain that have been deleted |
|
|
|
Cryptographic hash that was stored in the row of the chain with sequence number |
|
|
|
Cryptographic hash stored in the last row in this section of the chain with sequence number |
Note:
This view is available starting with Oracle Database 23ai.
See Also: