About
How to load a lob file with sql loader
Example
Control File
SQL*Loader - (Parameter|Control) File
LOAD DATA
INFILE 'sample.dat'
INTO TABLE person_table
FIELDS TERMINATED BY ','
(
name CHAR(20),
ext_fname FILLER CHAR(40),
"RESUME" LOBFILE(ext_fname) TERMINATED BY EOF
)
where:
- FILLER is a field that fill a variable named ext_fname. It takes the relative path from the sqlloader running directory to the file to load
- RESUME is the lob column of the database
- LOBFILE is a function that transform the file in a lob file where you can set the file characterset. See lobfile_spec for the complete syntax
Datafile (sample.dat)
Johny Quest,jqresume.txt,
Speed Racer,'/private/sracer/srresume.txt',