Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlloader question
what error do you get?
-- Regards, Daniel. "Shawn Edwards" <spedwards_at_qwest.net> wrote in message news:LTmv8.689$NU5.165342_at_news.uswest.net...Received on Wed Apr 17 2002 - 18:18:13 CDT
> Hi,
>
> I've been struggling trying to load a .csv file into my temp table. My
> table has 20 columns. But, not every line in the .csv file has 20 values.
> Some have 20, some 15 and some 10. But, only 2 columns are NOTNULL. And
> every line has those 2 values. But, I suspect that my problems are
stemming
> from the fact that not all of my lines in the .csv are 20 values for each
> column.
>
> So, my question is this. When loading a file is there a special procedure
> in creating the .csv file loading or additional step that I may have
missed
> with SQLOADER?
>
> Thanks
>
>