Re: shell scripting help

  • From: Sudhi <sudhi@xxxxxxxxxxxxx>
  • To: ldutra@xxxxxxxxxxxxx
  • Date: Thu, 04 Aug 2005 18:29:18 +0530

how about just putting the sql contents in a shell script and call it using 'nohup'

say :

1.sh
=====
sqlplus <username>/<password>@<connectString> <<EOF
select 'whatever you want to do goes here' from dual;
exit;
EOF

main.sh file
==============

nohup 1.sh >> /tmp/1.log &
nohup 2.sh >> /tmp/2.log &

Thats what I do for running things in bg.

Thanks,
-Sudhi.


--
Legal Disclaimer: The statements expressed here are of my own and do not represent those of Yahoo Inc !
--
//www.freelists.org/webpage/oracle-l

Other related posts: