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.
Description
Attribute |
Description |
|---|---|
| Type | Time |
| Default value | 0s |
| Value range | [0s, +∞) |
| Effective upon OBServer node restart | No |
recyclebin_object_expire_time can be set to the following values:
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";