OraFAQ Forum: Server Utilities » Multiple DB in a single sqlplus window

Home » RDBMS Server » Server Utilities » Multiple DB in a single sqlplus window (oracle 10.2.0.1.0 - windows XP)

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

Multiple DB in a single sqlplus window [message #493026]

Fri, 04 February 2011 05:52

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

One of my boss told, we can connect to many databases and can access them simultaneously in a single sqlplus window?

please can any one tell me is it possible, if it is then what is the procedure.

Regards:
Muktha

Report message to a moderator

Re: Multiple DB in a single sqlplus window [message #493029 is a reply to message #493026]

Fri, 04 February 2011 05:54

Littlefoot
Messages: 21781
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Via database links, true.

I can't think of any other way to be connected to different databases at the same moment from the same SQL*Plus session.

How come you didn't ask that person how to do that?

Report message to a moderator