Note
This parameter was introduced in OceanBase Database V4.3.4.
Description
The direct_load_allow_fallback parameter specifies whether to fall back to normal import when direct load fails during direct load bypass import.
Privilege requirements
Query the parameter
The
systenant and all user tenants can execute theSHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview to query the parameter.Modify the parameter
The
systenant and user tenants can modify the parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Bool |
| Default value | True
NoteThe default value of this parameter is changed from False to True starting from V4.3.5. |
| Value range |
|
| Modifiable | Yes. You can execute the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
- Whether you manually add a hint to control data import as direct load bypass import or configure the default_load_mode parameter to globally set data import as direct load bypass import, the system determines whether to fall back to normal import based on the value of the
direct_load_allow_fallbackparameter when direct load is not supported.
Example
The following example sets the parameter value to True, indicating that the system allows data import to fall back to normal import when direct load is not supported.
obclient> ALTER SYSTEM SET direct_load_allow_fallback = True;