Hi,
Somehow the maximum errors allowed in sql loader is 50 (default). How do I increase this to unlimited.

If you see the sample log file below it has allow all discards set. The loading stopts once it reaches 50 records in the bad file. I want it to continue and keep logging as many error in the bad file.

Thanks
Anurag

SQL*Loader: Release 8.0.5.0.0 - Production on Tue May 29 17:30:28 2001

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Control File: loaddata.ctl
Data File: ofasweb.txt
Bad File: ofasweb.bad
Discard File: ofasweb.dcs
(Allow all discards)


Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 65536 bytes
Continuation: none specified
Path used: Conventional