RE: shell scripting help

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Thu, 4 Aug 2005 07:42:27 -0500
Message-ID: <270A0BDDFDE54E41B78F0F06D82A66B801346CA1@okcexg3.kmg.com>

Don't run them in the background (&). The second and third statements won't run until the previous SQL finishes.  

Ron

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of d cheng
	Sent: Wednesday, August 03, 2005 4:49 PM
	To: Oracle-L_at_freelists.org
	Subject: shell scripting help
	
	
	Hi Listers,
	 
	I have a korn shell script which needs to run 3 sqlplus scripts

in parallel then run the final sqlplus script. Is there a way to ensure that sqlplus scripts 1 thru 3 completes before running the final sqlplus script? I am a newbie in shell scripting.          

	<< shell script snippet >>


	...

	sqlplus un/pw @script1.sql &
	sqlplus un/pw @script2.sql &
	sqlplus un/pw @script3.sql &


	...

	sqlplus un/pw @final.sql


	...

	exit
	 
	Thank you in advance for your help!
	 
	- David
	 

	__________________________________________________
	Do You Yahoo!?
	Tired of spam? Yahoo! Mail has the best spam protection around 
	http://mail.yahoo.com 

Important Notice!!
If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 04 2005 - 07:44:42 CDT