Note
The variable is no longer used. In V4.x, the TRUNCATE TABLE operation no longer supports the recycle bin. Although you can query and set the variable in V4.x, the related feature does not take effect.
Description
The ob_enable_truncate_flashback variable specifies whether to enable flashback for table truncation.
Privilege description
Query variables
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or viewSYS.TENANT_VIRTUAL_SESSION_VARIABLE(Oracle mode) andinformation_schema.SESSION_VARIABLES(MySQL mode) to query the values of session system variables.Modify variables
The
systenant and all user tenants can directly modify the values of session system variables in their own tenants.
Attribute description
| Attribute | Description |
|---|---|
| Type | Bool |
| Default value | OFF |
| Value range |
|
| Scope |
|
| Modifiable | Yes. You can use the SET statement to modify the variable. |
Examples
Enable flashback for table truncation.
Session level
obclient> SET ob_enable_truncate_flashback = ON;Global level
obclient> SET GLOBAL ob_enable_truncate_flashback = ON;