Re: Does Sqlldr Support Clob or Blob Columns?

Gene Hubert <ghubert_at_netpath.net> wrote in message news:AEC9BD4E43201D04.44CA659D3CE8132C.FFA8592CDC31655C_at_lp.airnews.net...
> 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
> >
>

SQL*Loader support for object types and the enhanced data types wasn't added until Oracle8i (8.1).

HTH. Finn Received on Mon Aug 23 1999 - 17:33:43 CDT