Query Across Multiple Databases

[subtonez]

Can anyone give a newbie a method for running a distributed query across multiple databases?

for example:
select *
from database1.table db1, database2.table db2
where db1.some_column=db2.some_column

 

[ouachita]

I am assuming the there is a database link to the other(s) instances.

select a.field1,a.field2,b.field1,b.field2
from mytable a, yourtable@database_link b
where a.field1=b.field2

 

[subtonez]

My problem is in setting up the link to the other database instance(s). I don't know how. Can you give me a quick-n-dirty method and/or point me to where I can find the method? I am using oracle 9i.

 

[subtonez]

Hey, I found out how on my own:

http://www.akadia.com/services/ora_dblinks.html