Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Loading in-line data in a CLOB
Andy Kent wrote:
> I am trying to load data into a table containing a CLOB. All the data
> is held in the one input file, rather than the CLOB data being held in
> separate files. Using the control file below (the CLOB column is
> "description") it works for rows where the input text is less than
> (very) roughly 80-100 bytes but gets "Field in data file exceeds
> maximum length" if the text is longer than this.
>
> Can this be done in SQL*Loader or do I need to use one of the DBMS
> packages?
>
> Thanks,
> Andy
>
>
> It's 9.2 on Windows 2000.
>
> Control file:
>
> LOAD DATA
> INFILE 'action.txt'
> BADFILE 'action.bad'
> DISCARDFILE 'action.dsc'
> TRUNCATE
> INTO TABLE action FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
> (id,description,date_ DATE(20) "DD/MM/YYYY
> HH:MI:SS",cleared,actionee,callreportno,client,opportunity,datedue,prospectno)
I would swear that I answered this same question within the last 12 hours. Look at DBMS_LOB.READ. Demo at www.psoug.org in Morgan's Library.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Fri Oct 14 2005 - 13:53:31 CDT