BLOCKCHAIN_TABLE_RETENTION_THRESHOLD

BLOCKCHAIN_TABLE_RETENTION_THRESHOLD lets you control the maximum amount of idle time that can be specified when a database user without the TABLE RETENTION system privilege creates or alters a blockchain table or an immutable table.

Property	Description
Parameter type	Integer
Default value	16
Modifiable	ALTER SYSTEM
Modifiable in a PDB	Yes
Range of values	0 to 365,000
Basic	No
Oracle RAC	The same value must be used on all instances.

The idle time for a non-empty blockchain table or a non-empty immutable table represents the length of time (in days) the table must be inactive before it can be dropped.

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