ALL_BLOCKCHAIN_TABLES

ALL_BLOCKCHAIN_TABLES describes the blockchain tables accessible to the current user.

Column Datatype NULL Description
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

See Also: