Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Accessing two Oracle databases

Re: Accessing two Oracle databases

From: joel garry <joel-garry_at_home.com>
Date: Tue, 30 Oct 2007 14:58:47 -0700
Message-ID: <1193781527.536248.326810@v29g2000prd.googlegroups.com>


On Oct 30, 11:35 am, jja..._at_hotmail.com wrote:
> 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?

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."
Received on Tue Oct 30 2007 - 16:58:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US