Re: Newbie seeking help with SQL*Loader

Thanks

Did you have to modify any of the table's properties?

Peter

krakowpat_at_yahoo.com wrote:
>
> Hello Peter,
>
> I don't have a solution for your problem, but I can say you that I use
> SQL*Loader to import 200 000 records in a table.
>
> Have a nice day,
>
> Patrice
>
> In article <37394BF3.54A9A603_at_cern.ch>,
> Peter Webb <Peter.Webb_at_cern.ch> wrote:
> > I'm currently using SQL*loader to up load a log file into a table for
> > processing, before it is discarded. However, the log file can be
> > anything from 1000 lines to 100000 lines.
> >
> > However, every now and then I encounter an a problem:
> > ...
> > Commit point reached - logical record count 61930
> > SQL*Loader-605: Non-data dependent ORACLE error occurred -- load
> > discontinued.
> >
> > Commit point reached - logical record count 61958
> >
> > Is there a upper limit? Or am I missing something.
> > Any help would be great appreciated in the diagnosis of this problem.
> >
> > Peter
> >
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---

--

-------------------------------------------------------     ////
CERN - European Laboratory for Particle Physics            (o o)
--------------------------------------------------------ooO-(_)-Ooo--
       IT Division  31 1-018    Tel:  +41 22 767 9414
       CERN                     Fax:  +41 22 767 7155
       CH-1211 Geneve 23        URL: http://home.cern.ch/~pwebb/

---------------------------------------------------------------------