Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlloader question

Re: sqlloader question

From: daniel <email_at_test.com>
Date: Thu, 18 Apr 2002 00:18:13 +0100
Message-ID: <a9kvaj$dlo$2@news8.svr.pol.co.uk>


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...

> 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
>
>
Received on Wed Apr 17 2002 - 18:18:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US