Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie seeking help with SQL*Loader
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.
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.
![]() |
![]() |