Re: Maximum errors allowed in sql loader.

Woah! Jerry, what did Mr. Bakker do to you ?

I have always found Sybrand Bakker replies to be informative.

There is an old adage that says when all else fails "read the book". By pointing someone to the appropriate documentation, you give the person the opportunity to enhance their knowledge which will benefit them. By telling someone how to do it, more than likely than will use it once and then forget.

"Jerry Metz" <jmetz1_at_ix.netcom.com> wrote in message news:3B142C45.42372181_at_ix.netcom.com...
> Since Mr. Bakker is obviously too busy to actually help you, and can only
> provide idiodic responses to you and everybody else that doesn't measure
 up to
> his rather high opinion of himself, let me take a crack at this one.
>
> As the first line in your control file, enter:
> OPTIONS (ERRORS=9999999)
>
> This will tell Loader to, in effect, ignore any error count less than 10
> million (in this case). If you expect more than 10 million errors, either
> increase the above parameter, or you really should consider sending the
> datafile back to it's owner.
>
> BTW, who died and made Bakker the moderator of this group. On multiple
> occasions he has indicated that the questioner should either get out of
 this
> group or they should RTFM. If he is soooooo busy that he doesn't have the
 time
> to help, maybe he ought to keep his mouth shut! It seems to me that the
> purpose of this and so many other of the newsgroups is for people to try
 and
> learn something. Maybe Mr. Bakker should join the group
> alt.win.friends.and.influence.people!
>
> Sybrand Bakker wrote:
>
> > "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 - 18:26:28 CDT