Re: Correct settings in SQL*Loader control file

From: Randy Harris <randy_at_SpamFree.com>
Date: Mon, 16 May 2005 21:43:39 GMT
Message-ID: <fu8ie.2414$tX5.334@newssvr33.news.prodigy.com>

<JimStrehlow_at_data911.com> wrote in message news:1116274345.637143.202340_at_o13g2000cwo.googlegroups.com...
> Randy Harris wrote:
> > I'm having problems with SQL*Loader.
> ... INTO TABLE evals_tmp
>
> Just a thought: You did not specify ownerName.evals_tmp
> so it is possible you may have accidentally created another evals_tmp
> table in another schema. You think you are inserting into table A.B
> when you actually are inserting into table C.B .
>
>
> You may specify either a bad file or a discard file to hold your
> errors.
>
> Jim

Good thought. Here, I thought I was being clever. Actually I am specifying the owner name but deleted that portion to "simplify" the post. Guess I shouldn't have done that. Thanks for the suggestion. Received on Mon May 16 2005 - 16:43:39 CDT