Re: Does Sqlldr Support Clob or Blob Columns?

Thanks, this is very helpful. To be more specific, I am using Oracle 8.0.5 and would much prefer not to write each clob to a separate text file as this appears to be doing. I know how to write each clob to a separate file but it just adds a lot of complexity and overhead to my data management process.

Currently I have everything working with writing an entire table to a text file and importing via sqlldr. However I have only been able to import the clob data to a long column. From there I have to use dynamic sql to piecewise read the long and convert it to a clob.

It would greatly simplify my process if sqlldr would import the clob data directly to a clob column.

Gene Hubert

On Sat, 21 Aug 1999 02:09:07 GMT, jonathan_at_gennick.com (Jonathan Gennick) wrote:

>On Fri, 20 Aug 1999 02:22:04 GMT, ghubert_at_netpath.net (Gene
>Hubert) wrote:
>
>>I've tried a bunch of things and have been unable to load directly
>>into clob columns with sqlldr. The docs seem to have nothing to say
>>on the matter.
>
>I've been able to load the contents of text files into CLOB
>fields. I recently did that using this control file:
>
>LOAD DATA
> INFILE 'animal_feeding_clob.csv'
> BADFILE 'animal_feeding_clob'
> APPEND
> INTO TABLE animal_feeding
> TRAILING NULLCOLS
> (
> animal_id INTEGER EXTERNAL TERMINATED BY ",",
> feeding_date DATE "dd-mon-yyyy" TERMINATED BY ",",
> pounds_eaten DECIMAL EXTERNAL TERMINATED BY ",",
> note_file_name FILLER CHAR TERMINATED BY ",",
> note LOBFILE (note_file_name)
> TERMINATED BY EOF
> )
>
>Does this help?
>
>Jonathan
>
>_____________________________________________________
>jonathan_at_gennick.com
>http://gennick.com
>Brighten the Corner Where You Are
>
Received on Sat Aug 21 1999 - 07:58:55 CDT