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 - 10:57:38 CST
