3.133 ALL_BLOCKCHAIN_TABLE_EPOCHS

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

Related Views

  • DBA_BLOCKCHAIN_TABLE_EPOCHS displays epoch information for all blockchain tables in the database.

  • USER_BLOCKCHAIN_TABLE_EPOCHS displays epoch 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

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

See Also: