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 view the value of global system variables.

  • 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 view the value of session system variables.

• Modify variables

  • Global level

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

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

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

  • Session level

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

Attributes

Usage notes

If you enable the recycle bin (recyclebin is set to ON), the deleted tables and their dependent objects are stored in the recycle bin. If you disable the recycle bin (recyclebin is set to OFF), the deleted tables and their dependent objects are directly deleted without being stored 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 in the recycle bin
• Purge the recycle bin