Overview
The default_load_mode parameter specifies the data import method in data import scenarios.
Privilege requirements
Query parameters
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 modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | String |
| Default Value | DISABLED |
| Value range |
|
| Modifiable | Yes, you can use the following methods:ALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
When importing data using the LOAD DATA INFILE statement, INSERT INTO SELECT statement, or CREATE TABLE AS SELECT statement without specifying any direct load hints, the default import mode is controlled by the default_load_mode parameter. If the import operation specifies the APPEND/DIRECT/NO_DIRECT hint, the data import mode is controlled by that hint.
Configuration example
In data import scenarios, set the data import mode to
FULL_DIRECT_WRITE.obclient [test]> ALTER SYSTEM SET default_load_mode ='FULL_DIRECT_WRITE';In data import scenarios, set the data import mode to
INC_DIRECT_WRITE.obclient [test]> ALTER SYSTEM SET default_load_mode ='INC_DIRECT_WRITE';
References
- Full direct load
- Data import overview