Re: query two instances on different machines

First you will need to create a database link from the first database to the second.
Then you can run this scripts in your first database:

 select A.field, B.field from T1 A, T1_at_second_database B  where A.field = B.field (+);

Hope this helps.

Bart.

In article <tno46.150$q31.386_at_news-srv1.fmr.com>,   "Lane Mabbett" <lane.mabbett_at_fmr.com> wrote:
> 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.
>
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 03 2001 - 04:40:26 CST