direct_load_allow_fallback

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 sys tenant and all user tenants can execute the SHOW PARAMETERS statement or query the GV$OB_PARAMETERS view to query the parameter.

• Modify the parameter

  The sys tenant and user tenants can modify the parameter.

Attributes

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_fallback parameter 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;

References

• Full direct load bypass import
• Incremental direct load bypass import