Un tour des solutions : http://eternal-donut.blogspot.com/2008/03/tip-1-blob-load-methods.html
SQLLoader est probablement le plus efficace : http://www.oracle-base.com/articles/10g/LoadLobDataUsingSqlLoader.php
The lob_test_data.txt file contains regular data and references to the files holding the CLOB and BLOB data.

1,one,01-JAN-2006,clob_test1.txt,blob_test1.doc
2,two,02-JAN-2006,clob_test2.txt,blob_test2.doc

Next, we define the SQL*Loader controlfile, called lob_test.ctl, that will allow us to load the data.

LOAD DATA
INFILE ‘lob_test_data.txt’
INTO TABLE lob_tab
FIELDS TERMINATED BY ‘,’
(number_content CHAR(10),
varchar2_content CHAR(100),
date_content DATE « DD-MON-YYYY » « :date_content »,
clob_filename FILLER CHAR(100),
clob_content LOBFILE(clob_filename) TERMINATED BY EOF,
blob_filename FILLER CHAR(100),
blob_content LOBFILE(blob_filename) TERMINATED BY EOF)

Notice that the filename columns in the datafile are marked as FILLERs, so they are not loaded into the table, but they are used in the LOBFILE definition to identify the loacation of the LOB information.

The data is then loaded using the following SQL*Loader command, run from the command line in the same directory as files.

sqlldr userid=test/test@db10g control=lob_test.ctl log=lob_test.log bad=lob_test.bad