OraFAQ Forum: Client Tools » To Run Sql script in background

Home » Other » Client Tools » To Run Sql script in background

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

To Run Sql script in background [message #647152]

Wed, 20 January 2016 13:59

rohit_shinez
Messages: 139
Registered: January 2015

Senior Member

Hi Guys,

I am executing two sql scripts from unix box by connecting through sqlplus from two putty sessions, i need to run the scripts in background is there a way to run apart from executing it from sh script.

SQL> @test.sql
.
.
.

Another session 

SQL> @test1.sql
.
.
.

Report message to a moderator

Re: To Run Sql script in background [message #647154 is a reply to message #647152]

Wed, 20 January 2016 14:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It depends upon what the scripts do.

Can you do the same from PL/SQL procedures?

Report message to a moderator

Re: To Run Sql script in background [message #647155 is a reply to message #647152]

Wed, 20 January 2016 14:46

rohit_shinez
Messages: 139
Registered: January 2015

Senior Member

No actutally i need to run the sql scripts in background so that my putty session will not disconnect basically my myscript does below


insert into T1
select * from T2 where id = 23;

Report message to a moderator

Re: To Run Sql script in background [message #647156 is a reply to message #647155]

Wed, 20 January 2016 14:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

https://www.gnu.org/software/screen/manual/screen.html

Report message to a moderator

Re: To Run Sql script in background [message #647157 is a reply to message #647152]

Wed, 20 January 2016 15:33

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Maybe you should envisage to feedback and thank people who help you.
Review your previous topics and do it.

Report message to a moderator

Re: To Run Sql script in background [message #647173 is a reply to message #647157]

Thu, 21 January 2016 04:20

JNagtzaam
Messages: 36
Registered: July 2015
Location: Alkmaar

Member

submit it as a one time job!? Can be done on the database as on UNIX.

Report message to a moderator

Re: To Run Sql script in background [message #647184 is a reply to message #647155]

Thu, 21 January 2016 06:55

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

rohit_shinez wrote on Wed, 20 January 2016 14:46

No actutally i need to run the sql scripts in background so that my putty session will not disconnect basically my myscript does below

And why would it cause your putty session to disconnect?
Is this meant to be manually submitted, or submitted by some job scheduling process, like cron?
In an earlier message you asked "is there a way to run apart from executing it from sh script". What are you envisioning here? If you are logged on to the server, you are already in a shell processor. You can launch sqlplus from there to execute your sql, or you can execute a shell script that in turn launches sqlpus.
Why are you using two putty sessions? What is that accomplishing?

Report message to a moderator

Previous Topic:	Does Oracle SQL Developer Support Unicode ?
Next Topic:	Hide SQL > statements in the spool file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 00:40:53 CST 2024