db:oracle:sqlloader_lob

Table of Contents

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',

Reference