Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Another SQL Loader problem
I do have an embedded carriage return. How do I handle that?
"Alan" <alanshein_at_erols.com> wrote in message
news:a7fnk8$kfbcc$1_at_ID-114862.news.dfncis.de...
> You probably have an embedded Carriage Return in the data. This is
> interpreted as an end of record unless you tell loader otherwise.
>
>
> "Ryan Gaffuri" <rkg100_at_erols.com> wrote in message
> news:6757365f.0203220759.31cd957f_at_posting.google.com...
> > Sorry about the multiple posts. Im at work and forced to use dejanews.
> >
> > Im getting the following error..
> >
> > Record 1: Rejected - Error on table TEST_NSN, column DOD_COMP.
> > Column not found before end of logical record (use TRAILING NULLCOLS)
> >
> >
> > However, I have this column set up with the FILLER keyword. Im on
> > Oracle 8i. Here is a sample of what I have done.
> >
> > LOAD DATA
> > INFILE 'd:\temp\file.txt'
> > TRUNCATE
> > INTO TABLE TEST
> > FIELDS TERMINATED BY '|'
> > OPTIONALLY ENCLOSED BY '"'
> >
> > (
> > ID_NO FILLER VARCHAR,
> > DOD_COMP FILLER VARCHAR,
> > TRI_SVC_COORD FILLER VARCHAR,
> > ITEM VARCHAR,
> > )
> >
> > Why am I getting that error?
>
>
Received on Fri Mar 22 2002 - 16:34:26 CST