Re: Newbie seeking help with SQL*Loader

From: Kevin Kubek <kkubek_at_hotmail.com>
Date: Wed, 12 May 1999 15:29:35 GMT
Message-ID: <7hc6on$935$1@nnrp1.deja.com>

The key phrase in the error message is "Non-data dependent". This usually indicates that a database issue is preventing the load from suceeding.

Could be any number of things like tablespace is full, max extents reached.
HTH 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
>

--
The Kubeks
'99 Coleman Bayside

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 12 1999 - 10:29:35 CDT