Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: query two instances on different machines
select * from tableA
minus
select * from tableA_at_yourdblink
-- Terry Dykstra Canadian Forest Oil Ltd. "Lane Mabbett" <lane.mabbett_at_fmr.com> wrote in message news:tno46.150$q31.386_at_news-srv1.fmr.com...Received on Wed Jan 03 2001 - 10:10:34 CST
> 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.
>
>
![]() |
![]() |