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

Home -> Community -> Usenet -> c.d.o.server -> Re: join between two tables of 2 differents databases mounted on 2 differents servers

Re: join between two tables of 2 differents databases mounted on 2 differents servers

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 28 Jan 2004 10:01:25 -0500
Message-ID: <Q_idnVeyvv1-U4rd4p2dnA@comcast.com>

"Laurent RUHLMANN" <lruhlmann_at_ingesoft.fr> wrote in message news:bv8gbj$af3$1_at_s1.read.news.oleane.net...
| Hi,
|
| I would like to to create a join select statement between 2 tables each
one
| being on different databases and different servers. I have created a link
| between the two databases but the remote table is not recognised when I do
| the select statement.
|
| Any idea ?
|
| Thanks,
|
| Laurent
|
|

more details would help:

db link definitions
sql statement that fails
db versions Received on Wed Jan 28 2004 - 09:01:25 CST

Original text of this message

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