SQL*Loader initiation problem

[itoheiko]

Hi there. A newbie question on SQL*Loader.

I am having real problems invoking SQL*Loader for Oracle 8 from DOS. When I type

C:\> sqlldr80

it generates the following error message:

Message 2100 not found; No message file for product=RBDMS80, facility=ULMessage

I have set my ORACLE_SID variable to my database e.g.

C:\> set ORACLE_SID=mydb

and have set ORACLE_HOME to the installation folder

C:\> set ORACLE_HOME=c:\orant

I understand that if I use

C:\> sqlldr80

I should get a list of vairables/options/methods.

Any idea what I'm doing wring? Cheers

al

 

[RJSHA1]

Hello there,

Is your ORACLE HOME DOS based ??? I you can find yuor ORACLE_HOME directory check and see if SQL LOADER has been set up there - there should be a directory like sqlload in there along with a sqlplus directory.

Failing that - do I what I always do talk to the DBA ( and see if it has been set up properly

Hope this helps

 

[itoheiko]

rjsha1,

Thanks for your help. I got the solution - the client installation was faulty. Corrected now...

Thanks again

G