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