OraFAQ Forum: Server Utilities » several hosts to sqlplus with only one connection??

Home » RDBMS Server » Server Utilities » several hosts to sqlplus with only one connection??

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

several hosts to sqlplus with only one connection?? [message #71618]

Wed, 04 December 2002 14:09

HoMmEr
Messages: 3
Registered: November 2002

Junior Member

I have to make severals hosts from FORMS 6i to the sqlplus.exe(with a script as parameter) to run some scripts.

There is any way to connect to sqlplus only one time, and in next hosts, run the scritps directly, without start connection again??????? I need it, pleaseee��

Or do you know any way i can do it???????

Thanks, and excuse for my bad english��

lesesigu@hotmail.com

Report message to a moderator

Re: several hosts to sqlplus with only one connection?? [message #71633 is a reply to message #71618]

Fri, 06 December 2002 08:46

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i dont know WHAT KIND OF SCRIPT you are mentioning here.
you can doo soemthing like this ( make sure u have
the appropriate tnsnames.ora entries in BOX this script is goin to be executed)

sqlplus user1/pass@host1
-- do your business
-- do your business
connect user2/pass@host2
-- do your business
-- do your busines
exit  -- exits out of sqlplus

Report message to a moderator

Previous Topic:	update statement
Next Topic:	Win 2000 and SQL Loader batch files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 17:12:35 CST 2024