Join between 2 tables on different servers

[Carlos Sérgio]

Good Morning!!

I would like to know how I can hold a join between 2 tables, on different B. servers.

grateful by the precious information and attention,

Carlos
carlosergio631@yahoo.com.br

[dr_gori]

It's simple!
You create a dblink between the two banks more or less like this:

Select all

create public database link BANCO1 
  connect to USUARIO 
  using 'SENHA'; 

Dai You do the SELECT that way:

Select all

select a.table_name 
from user_tables@banco1 a 
,    user_tables        b 
where a.table_name = b.table_name 

Remembering that to create public dblinks you have to be allowed and this is not very safe ...

Another important thing is that the TNS_NAMES.ORA of your server should contain the Information from the other server you want to access.

: -O

[Carlos Sérgio]

Thank you so much ! I learned one more !!

Valeu !!