These settings control the behavior of the recycle bin feature. In LightDB oracle mode, when user executes command DROP TABLE, the table and its dependencies will be put into recycle bin and wait for permanently deleted by background process.
enable_recyclebin
(boolean
)
Controls whether the command DROP TABLE logically remove the table file. This is on by default. User can set the parameter within the connection session.
recyclebin_clean_interval
(integer
)
Specifies the retention time of objects in recycle bin. The default is 2592000 secons, i.e. 30 days.