RE: SQL Loader Error Limit

RE: SQL Loader Error Limit

 

  

In your par file, add the following:

ERRORS=1000

-----Original Message-----
From: Ron Williams [mailto:[Email Address Removed] Friday, February 27, 2004 11:54 AM
To: LazyDBA.com Discussion
Subject: SQL Loader Error Limit


Hello all..

When i run SQLLDR it writes error records in a log file and stops if the
threshold of the records reaches 50. I guess that must be the default. How
do we change it to continue preocessing until it reaches say 1000.


Thanks
Ron
Oracle LazyDBA home page