Re: Newbie seeking help with SQL*Loader

Peter,

I do not understans well the question, thus I suppose no...

Patrice

In article <37399058.DC41404C_at_cern.ch>,   Peter Webb <Peter.Webb_at_cern.ch> wrote:
> 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/
> ---------------------------------------------------------------------
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 18 1999 - 03:01:51 CDT