Re: Connectstring with SQL*Loader

"Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote in message news:<1058536553.782862_at_news.thyssen.com>...
> is there any chance that your sqlldr and
> the sqlplus that you use reside in different
> oracle homes?
>
> Just a guess...
>
> Greetings,
> Guido

And a very good guess too!

Some time back, I installed Oracle Warehouse Builder. It installed in a new Oracle Home. Behind my back, it installed a new SQLLDR.exe in the new home. Then the £$€_at_£ bugger altered the Windows path, so the path to the new .exe comes BEFORE the old one. So when I try to execute the program, it finds the version in the wrong ORAHOME, and poooffff - there goes the neighbourhood.

Which, of course, explains why SQL*PLUS ran with no problems. OWB didn't include a .exe of that one, so Windows faithfully looked further on in the path and found it in the correct home

Thanks a lot, Guido.

/Bo Received on Mon Jul 21 2003 - 10:54:08 CEST