Maximum errors allowed in sql loader.
From: anuragmin <anurag_minocha_at_hotmail.com>
Date: Sat, 21 Jul 2001 21:46:12 GMT
Message-ID: <18.991168941390_at_iw1.mailusenet.com>
Bind array: 64 rows, maximum of 65536 bytes Continuation: none specified
Path used: Conventional
Posted via http://www.etin.com - the FREE public USENET portal on the Web Complete SEARCHING, BROWSING, and POSTING of text and BINARY messages! Received on Sat Jul 21 2001 - 23:46:12 CEST
Date: Sat, 21 Jul 2001 21:46:12 GMT
Message-ID: <18.991168941390_at_iw1.mailusenet.com>
Hi,
[Quoted] 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
Posted via http://www.etin.com - the FREE public USENET portal on the Web Complete SEARCHING, BROWSING, and POSTING of text and BINARY messages! Received on Sat Jul 21 2001 - 23:46:12 CEST