Re: how to compare and synchronize table rows

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 20 Mar 2003 16:48:11 +0800
Message-ID: <3E79804B.2C4D@yahoo.com>

oto pakozdy wrote:
>
> hello ...
>
> Is there any product or script to compare rows in two tables and do
> synchronization missing or changed rows ?
>
> Thans for advice...

See what the others have posted for one-off SQL solutions.

If you require to do it on a real-time basis, you'll need to use something like Oracle Replication or queueing

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"

Received on Thu Mar 20 2003 - 02:48:11 CST