sqlloader

[mgl70]

hello,
I am working on oracle 9.2.0.5.0 client version for windows xp.I have text data and try to load it into the oracle database.I created a control file.

when I am trying to give the sqlldr at dos prompt,

C:\sqlldr username/password@connectstring control=filename.ctl

it is giving the following error.

'sqlldr' is not recognized as an internal or external command, operable program or batch file.

I searched for sqlldr file in oracle home and other folders, but it is not there.

what should I do?

Thanks for your help

 

[SantaMufasa]

MQL,

cd to your ORACLE_HOME's \bin path and check there. If not, I would next do a Windows "File Search" for "sqlldr*".

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[mgl70]

Hi Mufasa,

I searched it. but it is not there.

Thanks.

 

[SantaMufasa]

Whoa, MGL, each time you try to run "sqlldr", are you entering the command that you posted above:

C:\sqlldr username/password@connectstring control=filename.ctl

If so, the problem is that "sqlldr" certainly is not in your root path on your "C:" drive.

Next thing to check: how many files are in your %ORACLE_HOME%\bin path?

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[mgl70]

Hi,

Yes, each time I gave the above command or C:\sqlldr, it is giving the same error.

It has 82 files in oracle_home/bin path. Sqlplus is also there. My oracle account is also working at sqlplus.

I donot know how sqlldr is missed/not loaded.

Is this the problem because of the client version.

Thanks.

 

[SantaMufasa]

MGL,

Keep in mind what I said earlier: even if you have "sqlldr" on your machine somewhere, it will NOT run as long as you try to invoke it with the literal path, "C:\" in front of "sqlldr"...'cuz "sqlldr" will never reside in "C:\".

If I was in your spot, and I couldn't find "sqlldr", I would try just copying the sqlldr executable for the same operating system and same version of Oracle over to my %ORACLE_HOME%/bin directory. That should run just fine.

I don't know why your install (even a client install) doesn't have "sqlldr"...it should.

Let us know how things turn out.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[mgl70]

Hi,
I understand what you said. But, in my case there is no sqlldr executable file in my system. where should I get a copy of the sqlldr executable for the same operating system and same version of Oracle.

Thanks.

 

[Turkbear]

Hi,
You need to run the Oracle Install program again and be sure the Utilities are selected;But, I have never known an Oracle client installation to lack Sqlldr.exe in <OracleHome>/bin

Who installed the Client software?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[mgl70]

Hi,

I only installed client version from networkdrive. I have not remember whether it asked about adding utilities.
I remember I clicked all. But, may be, I have not.

As you said, I need to reinstall it again the client.
Do you have anyidea about how to add utilities without the reinstallation.

ok. Thanks for your kind help/guidence.

Thanks.

 

[mgl70]

Hi,
This message is just for your info.

I did not reinstall it.
First, I did not know how to see whether the utilities are added or not.

I used custom and checked. The utilities were not added properly.


Added utilities. Now, sqlldr is working fine.

Thanks for your help.Closing this thread.