Re: shell scripting help

From: Sudhi <sudhi_at_yahoo-inc.com>
Date: Thu, 04 Aug 2005 18:29:18 +0530
Message-ID: <42F21126.4080606@yahoo-inc.com>

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 !
--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 04 2005 - 08:01:27 CDT