Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie seeking help with SQL*Loader

Re: Newbie seeking help with SQL*Loader

From: James Petts <jpetts_at_celltech.co.uk>
Date: Wed, 12 May 1999 10:39:54 GMT
Message-ID: <37395a1b.185814296@right.celltech>


On Wed, 12 May 1999 11:37:55 +0200, 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

Look at the documentation, especially the Action recommended for this error, viz: See the errors below this one in the log file for more information.



SQL*Loader-605 non-data dependent Oracle error occurred load discontinued

Cause: An error occurred that is independent of the data. For example, an out-of-space condition. Because all further rows will be rejected, the load is discontinued. (If the error were data dependent, then other rows might succeed.)

Action: See the errors below this one in the log file for more information.


Received on Wed May 12 1999 - 05:39:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US