Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Another SQL Loader problem
Looks like you have a column that is empty, likely the last column.
Use the keyword
TRAILING NULLCOLS And this will fix your problem.
JP
rkg100_at_erols.com (Ryan Gaffuri) 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 - 13:57:37 CST