Overview
enable_auto_split specifies whether to enable automatic partitioning for a tenant.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Both the
systenant and user tenants can use theALTER SYSTEM SETstatement to modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | BOOL |
| Default Value | FALSE |
| Value range |
|
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
You can execute the ALTER SYSTEM SET statement to modify the value of a parameter.
The enable_auto_split parameter determines whether to create an auto-partitioned table when the table creation statement does not explicitly specify automatic partitioning using the AUTOPARTITION clause. If the table is explicitly set to use automatic partitioning, this parameter does not take effect.
- If
enable_auto_splitis set totrue, a table will be automatically partitioned only if it meets the requirements for automatic partitioning upon creation. - If
enable_auto_splitisfalseand later changed totrue, this change does not take effect on existing tables that meet the auto-partitioning criteria; it only takes effect on newly created tables.
For more information about automatic partitioning, see Automatic partition splitting.
Configuration example
Enable automatic partitioning.
ALTER SYSTEM SET enable_auto_split = TRUE;