SQL Loader Problem

Hi All,

We are facing a problem while loading data using SQL Loader. The exact problem is:

There is a file containing around 40,000 records which is read by a Java code and then loaded into the DB throug SQL Loader. When we run this through our local envioronment, it does the job sucessfully.

However, when we run the same in DEV env (which is similar to our production env) it inserts few records (around 8000) and thereafter does not repond for a log time and when we kill the job (using Ctrl C) it gives an error saying

SQL*Loader-2028: load discontinued to user interrupt (Ctrl-C) [4]

Specify SKIP=8321 when continuing the load.

Please do reply ASAP.

cheers

amit

[723 byte] By [dumba] at [2007-11-27 1:10:03]