recyclebin

Description

recyclebin specifies whether to enable the recycle bin.

Privilege requirements

• Query variables

  • Global level

    sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) or the information_schema.GLOBAL_VARIABLES view (MySQL mode) to obtain the value of a global system variable.

  • Session level

    sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) or the information_schema.SESSION_VARIABLES view (MySQL mode) to obtain the value of a session system variable.

• Modify variables

  • Global level

    • sys tenant can directly modify the value of a global system variable.

    • MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the value of a global system variable.

    • Oracle user tenants must have the ALTER SYSTEM privilege to modify the value of a global system variable.

  • Session level

    sys tenant and all user tenants can directly modify the value of a session system variable.

Attributes

Usage notes

If you enable the recycle bin (recyclebin is set to ON), the deleted tables and their dependent objects will be placed in the recycle bin. If you disable the recycle bin (recyclebin is set to OFF), the deleted tables and their dependent objects will be directly deleted without being placed in the recycle bin.

Examples

Enable the recycle bin.

• Session level

  obclient> SET recyclebin = ON;
  

• Global level

  obclient> SET GLOBAL recyclebin = ON;
  

References

For more information about recycle bin operations, see the following topics:

• Enable or disable the recycle bin
• View objects in the recycle bin
• Restore objects from the recycle bin
• Purge the recycle bin