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: Brian Tkatch <N/A>
Date: Wed, 31 Oct 2007 10:51:48 -0400
Message-ID: <gj5hi39j29akbijq1iv15scog0kskovo0u@4ax.com>


On Tue, 30 Oct 2007 14:58:47 -0700, joel garry <joel-garry_at_home.com> wrote:

>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.

And in the 90s i heard of ODBC. :)

B.

>jg
Received on Wed Oct 31 2007 - 09:51:48 CDT

Original text of this message

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