How to load a lob file with sql loader
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:
Johny Quest,jqresume.txt,
Speed Racer,'/private/sracer/srresume.txt',