| sqlldr program [message #147682] |
Sat, 19 November 2005 02:00  |
Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore
|
Senior Member |
|
|
Hi,
I am trying to run a sql loader program in my machine(OS Windows NT).
When i tried to execute my sql loader program , its giving me an error like 'sqlldr' is not recognized as an internal or external command , operable program or batch file.
Please kindly let me know what could be the problem & how to go about it.
Best Regards
Safeeq
|
|
|
|
|
|
|
|
| Re: sqlldr program [message #147802 is a reply to message #147800] |
Mon, 21 November 2005 03:05  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
@Safeeq.S
I suppose, the path variable on your machine is not set properly.
what is the output if you write
C:\> path
And as "Anacedent" said, go to ORACLE_HOME/bin location from the command prompt and then try to execute, it should work.
|
|
|
|
|
|
| Re: sqlldr program [message #147823 is a reply to message #147809] |
Mon, 21 November 2005 05:03 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Ok now check the existence of SQLLDR.exe, do this
D:\oracle\ora92\bin>dir sqll*.exe
Volume in drive D has no label.
Volume Serial Number is 603B-9EE6
Directory of D:\oracle\ora92\bin
04/28/2002 11:07 AM 364,816 SQLLDR.EXE
1 File(s) 364,816 bytes
0 Dir(s) 4,387,684,352 bytes free
Try on your machine and post back.
Now i am afraid about the existence of SQLLDR exe.
|
|
|
|
| Re: sqlldr program [message #147831 is a reply to message #147682] |
Mon, 21 November 2005 05:31 |
Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore
|
Senior Member |
|
|
Yes. As you suspected i couldnt find sqlldr.exe in "c:\orant\bin" directory...!!!
so do i need to install the oracle again and is it possible to install sql loader seperately?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
