Re: query two instances on different machines

create a database link from database a to database b (making sure the tnsnames.ora on the server for database a lists database b) then issue
select * from foo
minus
select * from foo@<database link to b>

and that should be all.
Please refer to the sql reference manual on to how create a database link

Hth,
Sybrand Bakker, Oracle DBA

"Lane Mabbett" <lane.mabbett_at_fmr.com> wrote in message news:tno46.150$q31.386_at_news-srv1.fmr.com...
> Greetings. How is it possible (if at all) to execute a query on two
> instances located on separate servers? I'm told it can be done but am at
 a
> loss. I have two databases that should contain the exact same
 information.
> However, one database has more records than the other. I need to write a
> select statement that will show what records exist in one database that do
> not exist in the other. Thanks in advance.
>
>
Received on Wed Jan 03 2001 - 00:05:44 CST