BL_DIRECT_PATH= Data Set Option

Sets the Oracle SQL*Loader DIRECT option.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: YES
Requirement: To specify this option, you must first set BULKLOAD=YES.
Data source: Oracle
See: BULKLOAD= data set option

Syntax

BL_DIRECT_PATH=YES | NO

Syntax Description

YES
sets the Oracle SQL*Loader option DIRECT to TRUE, letting the SQL*Loader use Direct Path Load to insert rows into a table.
NO
sets the Oracle SQL*Loader option DIRECT to FALSE, letting the SQL*Loader use Conventional Path Load to insert rows into a table.

Details

Conventional Path Load reads in multiple data records and places them in a binary array. When the array is full, it is passed to Oracle for insertion and Oracle uses the SQL interface with the array option.
Direct Path Load creates data blocks that are already in the Oracle database block format. Blocks are then written directly into the database. This method is significantly faster, but there are restrictions. For more information about the SQL*Loader Direct and Conventional Path loads, see your Oracle utilities documentation for SQL*Loader.