Re: Newbie seeking help with SQL*Loader

From: <krakowpat_at_yahoo.com>
Date: Wed, 12 May 1999 10:53:00 GMT
Message-ID: <7hbmia$qrh$1@nnrp1.deja.com>

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.--- Received on Wed May 12 1999 - 05:53:00 CDT