recyclebin_object_expire_time specifies the lifetime of a schema in the recycle bin. A schema reached its lifetime in the recycle bin is automatically purged.
Description
| Property | Description |
|---|---|
| Parameter type | Time |
| Default value | 0s |
| Value range | [0s, +∞) |
| Effective upon OBServer restart | No |
recyclebin_object_expire_time can be:
0s: Automatic purging is disabled; or
A value other than 0s: Schemas that have remained in recycle bin for the specified time will be purged.
Examples
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";
