recyclebin_object_expire_time specifies the lifetime of a schema in the recycle bin. A schema that reached its lifetime in the recycle bin is automatically purged.
Parameter |
Description |
|---|---|
| Type | Time |
| Default value | 0s |
| Value range | [0s, +∞) |
| Effective upon restart of OBServer node | No |
recyclebin_object_expire_time can be set to:
0s: Automatic purging is disabled.
A value other than 0s: Schemas that have remained in recycle bin for the specified time will be purged.
Example
Disable automatic purging:
obclient> ALTER SYSTEM SET recyclebin_object_expire_time = "0s";
Enable automatic purging and purge schemas that entered the recycle bin seven days ago:
obclient> ALTER SYSTEM SET recyclebin_object_expire_time = "7d";