SQL Loader
Program Name : sqlldr
Loading delimited (variable length) data
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( data1, data2 ) BEGINDATA 11111,AAAAAAAAAA 22222,"A,B,C,D,"
Loading positional (fixed length) data
INTO TABLE emp ( data1 POSITION(1:5), data2 POSITION(6:15) ) BEGINDATA 11111,AAAAAAAAAA 22222,"A,B,C,D,"
To Skip header rows
OPTIONS (SKIP=5)
Selective Loading
INTO TABLE my_selective_table WHEN (01) <> 'H' and (01) <> 'T' and (30:37) = '20031217'
ROWS= parameter to a large value - to tell when to commit
DIRECT=TRUE. This will effectively bypass most of the RDBMS processing. However, there are cases when you can't use direct load.
The conventional path loader essentially loads the data by using standard INSERT statements.
The direct path loader (DIRECT=TRUE) bypasses much of the logic involved with that, and loads directly into the Oracle data files. .
Some of the restrictions with direct path loads are: Loaded data will not be replicated
Cannot always use SQL strings for column processing in the control file (something like this will probably fail: col1 date "ddmonyyyy" "substr(:period,1,9)").
Program Name : sqlldr
Loading delimited (variable length) data
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( data1, data2 ) BEGINDATA 11111,AAAAAAAAAA 22222,"A,B,C,D,"
Loading positional (fixed length) data
INTO TABLE emp ( data1 POSITION(1:5), data2 POSITION(6:15) ) BEGINDATA 11111,AAAAAAAAAA 22222,"A,B,C,D,"
To Skip header rows
OPTIONS (SKIP=5)
Selective Loading
INTO TABLE my_selective_table WHEN (01) <> 'H' and (01) <> 'T' and (30:37) = '20031217'
ROWS= parameter to a large value - to tell when to commit
DIRECT=TRUE. This will effectively bypass most of the RDBMS processing. However, there are cases when you can't use direct load.
The conventional path loader essentially loads the data by using standard INSERT statements.
The direct path loader (DIRECT=TRUE) bypasses much of the logic involved with that, and loads directly into the Oracle data files. .
Some of the restrictions with direct path loads are: Loaded data will not be replicated
Cannot always use SQL strings for column processing in the control file (something like this will probably fail: col1 date "ddmonyyyy" "substr(:period,1,9)").
Comments