OraFAQ Forum: Unix » unable to execute sqlldr with ftp in single shell scripts

Home » Infrastructure » Unix » unable to execute sqlldr with ftp in single shell scripts

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unable to execute sqlldr with ftp in single shell scripts [message #142262]

Fri, 14 October 2005 00:09

rajeshkumar
Messages: 5
Registered: October 2005
Location: New Delhi

Junior Member

Hi all

I'm trying to execute a unix shell scripts which helps me to ftp file from unix server to sun.(its working) but parallely i'm trying to write sqlldr commnad in same scripts & it wont work.
Can some one help.

This is Working

ftp -vin 10.1.1.4 <<!
user root btsolin123
ascii
cd /tmp
lcd /home/oracle/scripts
get vpn4.txt
bye
========================================================
if i'm writing like that it termiante after bye.
ftp -vin 10.1.1.4 <<!
user root btsolin123
ascii
cd /tmp
lcd /home/oracle/scripts
get vpn4.txt
bye
sqlldr userid=username=passwd control= file.ctl log=file.log

Report message to a moderator