SCHEMA_NAME

VARCHAR2(128)

NOT NULL

The schema containing the blockchain table

TABLE_NAME

VARCHAR2(128)

NOT NULL

Name of the blockchain table

ROW_RETENTION

NUMBER

Row retention period for the blockchain table, that is, the minimum number of days a row must be retained and cannot be deleted after it is inserted into the table

If the value of this column is NULL, then rows can never be deleted from the table.

ROW_RETENTION_LOCKED

VARCHAR2(3)

Indicates whether the row retention period for the blockchain table is locked. Possible values:

• YES: The row retention period is locked. You cannot change the row retention period

• NO: The row retention period is not locked. You can change the row retention period to a value higher than the current value with the SQL statement ALTER TABLE … NO DELETE UNTIL n DAYS AFTER INSERT

TABLE_INACTIVITY_RETENTION

NUMBER

Number of days for which the blockchain table must be inactive before it can be dropped, that is, the number of days that must pass after the most recent row insertion before the table can be dropped

A table with no rows can be dropped at any time, regardless of this column value.

HASH_ALGORITHM

VARCHAR2(8)

Algorithm used for computing the cryptographic hash for each table row

TABLE_VERSION

VARCHAR2(7)

Blockchain table version. Possible values:

• V1

• V2

CURRENT_EPOCH

NUMBER

Current epoch number for the blockchain table

MAX_SYSTEM_CHAINS

NUMBER

Number of system chains in each database instance that can link rows with a cryptographic hash

DELETE_TIME

TIMESTAMP(6) WITH TIME ZONE

Youngest threshold used to delete rows in the blockchain table