Re: utility to synchronize tables over a database link
From: Patrick Sinke <patrick.sinke_at_capgemini.nl>
Date: Mon, 7 May 2001 16:53:56 +0200
Message-ID: <989249709.12053_at_sleeper.capgemini.nl>
Date: Mon, 7 May 2001 16:53:56 +0200
Message-ID: <989249709.12053_at_sleeper.capgemini.nl>
I think a post-insert/update trigger (for each row) would be the most useful
solution.
Mind you that perfomance may drop!
Another solution is, to do all the dml-statements on those tables via a
package, and always update the two tables at the same time.
Regards,
Patrick Sinke
Cap Gemini Ernst & Young, sector Financial Services
Matthijs Rademakers <Matthijs.Rademakers_at_nos.nl> schreef in berichtnieuws
9d66vk$kdg$1_at_porthos.nl.uu.net...
> Hi,
>
> Does anybody know of a utitlity (pl/sql-package) to synchronize the
contents
> of two identical tables over a database link?
>
> Your tips are appreciated!
>
> Matthijs Rademakers
>
>
Received on Mon May 07 2001 - 16:53:56 CEST