Note
This parameter was introduced in V4.3.4.
Description
The default_load_mode parameter specifies the default data import mode in a data loading scenario.
Privilege requirements
Query the parameter
The
systenant and all user tenants can execute theSHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview to obtain the value of this parameter.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | String |
| Default value | DISABLED |
| Value range |
|
| Modifiable | Yes. You can execute the ALTER SYSTEM SET statement to modify this parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
When you import data by using the LOAD DATA INFILE statement, the INSERT INTO SELECT statement, or the CREATE TABLE AS SELECT statement without specifying a hint for direct load, the data import mode is controlled by the default_load_mode parameter. If the APPEND/DIRECT/NO_DIRECT hint is specified in the data loading statement, the data import mode is controlled by the hint.
Example
Set the data import mode for data loading operations to
FULL_DIRECT_WRITE.obclient [test]> ALTER SYSTEM SET default_load_mode ='FULL_DIRECT_WRITE';Set the data import mode for data loading operations to
INC_DIRECT_WRITE.obclient [test]> ALTER SYSTEM SET default_load_mode ='INC_DIRECT_WRITE';