Home » Infrastructure » Linux » sqlldr
sqlldr [message #202227] Wed, 08 November 2006 17:57 Go to next message
islheg
Messages: 2
Registered: November 2006
Junior Member
Hi Hi

I want to load data from files into an Oracle DB. I tried to invoke the sqlldr command from a linux machine, but it gave me: command not found. I want to know if anyone has an idea on how to load data from files or what is wrong with the sqlldr command.

islheg
Re: sqlldr [message #202238 is a reply to message #202227] Wed, 08 November 2006 19:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Make sure you have ORACLE_HOME defined and $ORACLE_HOME/bin is in your PATH
Re: sqlldr [message #202248 is a reply to message #202238] Wed, 08 November 2006 20:03 Go to previous messageGo to next message
islheg
Messages: 2
Registered: November 2006
Junior Member
Do you mean the Oracle installation folder by ORACLE_HOME? and where should it be defined?
Re: sqlldr [message #204207 is a reply to message #202227] Sun, 19 November 2006 00:26 Go to previous message
prabhakarkamath
Messages: 13
Registered: February 2006
Junior Member
export the ORACLE_HOME in the shell prompt before you run the sqlldr command..like here below

$ export ORACLE_HOME=/u01/oracle/product/10.0.1.2/db_1/bin
$ sqlldr #enter the command here

Cheers
Previous Topic: Problem with File Retention Script and Cron Job
Next Topic: Oracle: read error
Goto Forum:
  


Current Time: Thu Dec 08 00:05:55 CST 2016

Total time taken to generate the page: 0.09835 seconds