| Scheduling sqlldr in crontab -- solution pls!!! [message #72562] |
Wed, 16 July 2003 23:59  |
Rashmi
Messages: 20
Registered: April 2001
|
Junior Member |
|
|
Hi All,
I have a script that ftps a file to my home dir and loads it in table using the sqlldr. When I run this script manually from the command prompt it runs fine & loads the records generating the log & bad file.
But when I put in crontab it does not run & the error thrown is sqlldr not found.
The oracle version is 8.1.6 on solaris 8.
Why does this happen?? Any solutions ??
Thanks & Regards
Rashmi
|
|
|
|
|
|
| Re: Scheduling sqlldr in crontab -- solution pls! [message #74230 is a reply to message #72565] |
Thu, 14 October 2004 14:30  |
Marcelo
Messages: 4
Registered: March 2002
|
Junior Member |
|
|
I got same problem :-(
my (little) script:
for arq in `ls *.txt`
do
cat $arq | tr "n" " " >> logger.out
echo "" >>logger.out
rm $arq
done
./sqlldr $DBUSER/$DBPASSWORD@$DBSCHEMA data = ./logger.out control = control.ctl log = log.out bad = log.bad errors = 50000 >> log_execucao.log
rm logger.out
exit 0
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
