recyclebin_object_expire_time specifies whether to automatically purge expired schemas from the recycle bin.
| Attribute | 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";