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.