Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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