ALL_BLOCKCHAIN_TABLE_EPOCHS

ALL_BLOCKCHAIN_TABLE_EPOCHS displays epoch information for the blockchain tables accessible to the current user.

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
EPOCH_NUMBER NUMBER   Epoch number
EPOCH_NAME VARCHAR2(11)  

Epoch name describes the reason for the epoch and is one of the following values:

  • CREATE

  • IMPORT

  • ADD COLUMN

  • DROP COLUMN
PDB_GUID RAW(16)   Global unique identifier of the pluggable database where the blockchain table epoch was created
HASH_ALGORITHM VARCHAR2(8)  

Algorithm used for computing the cryptographic hash on each row produced in the epoch

The value of this column is always SHA2_512.

HASH_DATA_FORMAT_VERSION NUMBER   Hash data format version for the epoch
START_TIME TIMESTAMP(6) WITH TIME ZONE   Time at which the epoch was created

Note: This view is available starting with Oracle AI Database 26ai.

See Also: