sqlldr not found when using SQL*Loader in a shell script

sql shell oracle-sqldeveloper sql-loader
Angelina picture Angelina · May 17, 2013 · Viewed 35.3k times · Source

I would like to create shell script, AUTOLOAD that will, when ran, execute SQL*Loader with a set of instructions. All this is in my Linux environment.

SQL*loader will then import data to SQL developer

#!/bin/sh
#
echo -------- SQL loader --------
# @echo; 
#
sqlldr username@server1/password control=/folder1/ctrl/loader.ctl log=/folder1/load/results.l

My shell script is located in root directory and this is where I will be calling other files from. But it is giving me error when I try to run it:

- line 6: sqlldr: command not found

I don't know how to specify path to SQL*Loader, since I am on Linux.

I am new to this...so Be gentle :(

Answer

glenn jackman picture glenn jackman · May 17, 2013

Try

locate sqlldr

That should return something like

/u01/app/oracle/product/11.2.0/xe/bin/sqlldr

Edit your ~/.profile and add at the bottom

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
PATH="$PATH:$ORACLE_HOME/bin"

Then re-load your profile with source ~/.profile (or log out and log back in), and you should be good to go.

Related questions

How do i execute oracle Query using shell Scripting and send the results in the email

I am new to Unix scripting.. I have an oracle DB which has a username, password, hostname, port and servicename. I want to connect the database and run the query and in the end the result should be email to …

Read More
suppressing messages while running sql queries in a script

I am trying to write a simple query-script that gets me cnt of rows in a table. However I am facing problem to suppress all sorts of oracle messages. All I am interested is the output: Here is my script: #!/…

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More