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

Ok it works now.

The domain of the remote server was of course not the same, so I had to indicate it when I created my dblink :
create public database link db2.domain2 connect to user2 identified by pass2 using 'db2'
If I forget the domain Oracle will suppose that it's the local domain and will create the database link db2.domain1 !!!

Test :

connect user1/pass1_at_db1;
select * from tab2_at_db2.domain2;

Bye,

Laurent

"Laurent RUHLMANN" <lruhlmann_at_ingesoft.fr> a écrit dans le 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
>
>
Received on Wed Jan 28 2004 - 10:13:25 CST