Connectstring with SQL*Loader

I have a problem trying to run SQL*Loader after migrating to Oracle 9. It used to run with no hicups on Oracle 8i, and I'm at my wits' end. Any help?

I'm trying to run SQL*Loader from a command prompt (I'm on Oracle 9i R1 and WinXP professional), and fail to connect to the database.

The command at the promt is like this:

   sqlldr bbc/password_at_bbc control = C:\...path to controlfile

SQL*Loader then runs but fails with the message, that TNS cannot resolve the servicename (ORA-12154).

I know, and have re-checked, that the service "bbc" IS defined.

If I then retry without naming the service, I would expect SQL*Loader to connect to my local (default) database, which happens to be the same as the one defined in "bbc". Same problem, same message.

I can, with absolutly no problem, run SQL*Plus from a commandline, invoking it with the same connectstring. It works fine, both with and without specifying the servicename.

I'm almost out of hair to tear out now. Anyone can give me a clue?

Best,

Bo Brunsgaard
Vitus Bering CVU. Received on Fri Jul 18 2003 - 15:15:16 CEST