Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Maximum errors allowed in sql loader.
"anuragmin" <anurag_minocha_at_hotmail.com> wrote in message
news:19.991168941390_at_iw1.mailusenet.com...
> 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
>
>
> ----
> Posted via http://www.etin.com - the FREE public USENET portal on the Web
> Complete SEARCHING, BROWSING, and POSTING of text and BINARY messages!
Check the Oracle Server Utilities Manual as to how you can specify the discardmax option on the commandline.
Hth,
Sybrand Bakker, Oracle DBA Received on Tue May 29 2001 - 17:32:10 CDT