Is it possible to access two different Oracle databases located on
two separate servers within a tool such as Oracle SQL Developer or
PL/SQL Developer simultaneously?

jjablt (AT) hotmail (DOT) com wrote:
Define two connections in SQL Developer. Then double click on each of
them. You will have two panels in SQL Developer, each connected to a
different instance. You cannot have one panel simultaneously connected
to two different instances.

HTH,
Brian

--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com

On Oct 30, 11:35 am, jja... (AT) hotmail (DOT) com wrote:
I've managed to do this on other tools with tricky synonym & dblink
usage, but generally more trouble than it is worth, and slow. You
might need a third schema to mash it together.

In the '80's I saw a tool that could directly join across database
engines.

jg
--
@home.com is bogus.
"So Mr. Moviephone says you should see Saw?"
"No."

jjablt (AT) hotmail (DOT) com wrote on 30.10.2007 19:35:

A join across tables in different databases?

On Tue, 30 Oct 2007 14:58:47 -0700, joel garry <joel-garry (AT) home (DOT) com>
wrote:

And in the 90s i heard of ODBC.

B.

On Oct 31, 7:51 am, Brian Tkatch <N/A> wrote:
And you've been "updating drivers" ever since! :-)

jg
--
@home.com is bogus.
ftp://ftp.stratus.com/pub/vos/multics/pg/cookie.pl1