sqlloader shell script

Question posted by: orajit (Member) on June 18th, 2008 06:44 AM

Hi am calling sqlloader inlow shell script

#!/bin/sh
sqlldr scott/tiger control=ulcase1.ctl log=ulcase1.log
retcode=`echo $?`
case "$retcode" in
0) echo "SQL*Loader execution successful" ;;
1) echo "SQL*Loader execution exited with EX_FAIL, see logfile" ;;
2) echo "SQL*Loader exectuion exited with EX_WARN, see logfile" ;;
3) echo "SQL*Loader execution encountered a fatal error" ;;
*) echo "unknown return code";;
esac

#!/bin/ksh

while read table_name
do
echo "

I have set database name as scott/tiger .

I have following queries

1) what need to be done if i need to call that shell script in another database .
Means everytime its not posible to change the database name ..

is there any automatic process for it

thanks

Not the answer you were looking for? Post your question . . .
183,906 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).