Re: Newbie seeking help with SQL*Loader

From: Alex Cheung <alexcheung_at_onramp.ca>
Date: Wed, 12 May 1999 22:22:20 -0400
Message-ID: <SDq_2.5590$qQ4.120219@news2.giganews.com>

Peter :

Check your SQL*loader manual and make sure you use commit =y parameter. If you don't, Sql*loader
commits when 64K buffer fills up with data.

Alex Cheung
alexcheung_at_onramp.ca

Peter Webb wrote in message <37394BF3.54A9A603_at_cern.ch>...
>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
Received on Wed May 12 1999 - 21:22:20 CDT