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 […]
Commentaires