Re: Maximum errors allowed in sql loader.

Jerry Metz wrote:

> 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.
>

Jerry,

I actually quite enjoy Mr. Bakker's responses. Some I actually find entertaining. You must concede, that he does not merely reply "RTFM", but usually provides a clue that the poster *might* follow-up on through a search through the documentation (which is publicly available). His post below was not mean, but instructive. Maybe a quick whack across the nose with the reference to the manual is exactly what someone might need in order to realize that a keyword search will return their answer much faster than another person's RTFM reply.

As far as being "moderator" - he is knowledgeable in the art - and has ascended to *guru* here in all things not related to NT - but is not the moderator. Its like anything else - if you want his knowledge, you have to tolerate his opinions also - or skip his posts - the option is yours (everyone's).

Paul
BDBAFH
>
> 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.
> > >
> > 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 Wed May 30 2001 - 11:14:13 CDT