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

Report message to a moderator

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: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Make sure you have ORACLE_HOME defined and $ORACLE_HOME/bin is in your PATH

Report message to a moderator

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?

Report message to a moderator

Re: sqlldr [message #204207 is a reply to message #202227] Sun, 19 November 2006 00:26 Go to previous message
prabhakarkamath
Messages: 15
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jan 22 03:31:43 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.