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