| How to install sql*loader in ubuntu [message #217331] |
Thu, 01 February 2007 14:07  |
jocelyn
Messages: 2
Registered: February 2007
|
Junior Member |
|
|
Hi,
I have a problem in starting or installing SQL*Loader in Ubuntu. Im using Oracle Database 10g(XE). I tried to execute the command "sqlldr" but the reponse was "command not found" I have found the path in my bin folder. I run it in the terminal and this were the results:
jocelyn@jocelyn-desktop:~$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlldr
Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility=ULjocelyn@jocelyn-desktop:~$
I dont know whats wrong. Can anybody help me? Pls. I need to solved this problem. Thank you.
Best regards,
jocelyn
|
|
|
|
|
|
| Re: How to install sql*loader in ubuntu [message #217337 is a reply to message #217331] |
Thu, 01 February 2007 14:39  |
jocelyn
Messages: 2
Registered: February 2007
|
Junior Member |
|
|
Hi Ebrian,
Thank you for your reply. I know my oracle home and path were set correctly. Do you have any other idea what other wrong I might have since I cannot execute sqlldr? I really need help pls.
Thank you,
jocelyn
|
|
|
|
|
|
| Re: How to install sql*loader in ubuntu [message #217355 is a reply to message #217337] |
Thu, 01 February 2007 16:12 |
Admin@Lightsql.Com
Messages: 36
Registered: November 2006
|
Member |
|
|
Hi,
Are you able to connect through sqlplus (instead of sqlldr)?
On either case, check there are some messages files in ORACLE_HOME and below, especially below network directory, and look at the privileges. You need to give read priv to public. I happen to see this in one linux installation, but do not remember the exact location of the message files. It was set right when priv are given.
Good luck
Jay - Programming with Oracle & Visual C++, Author of http://www.lightsql.com.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
