Note
This variable is no longer available. In V4.x, the TRUNCATE TABLE operation no longer supports moving data to the recycle bin. Although you can still query and set this variable in V4.x, the related feature does not take effect.
Description
ob_enable_truncate_flashback specifies whether to enable flashback for table truncation.
Privilege requirements
Query variables
In the
systenant and all user tenants, you can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle mode) or theinformation_schema.SESSION_VARIABLESview (MySQL mode) to view the value of a session system variable.Modify variables
In the
systenant and all user tenants, you can directly modify the value of a session system variable in the current tenant.
Attributes
| Attribute | Description |
|---|---|
| Type | Boolean |
| Default value | OFF |
| Value range |
|
| Scope |
|