Synchronizing data between different databases/tables
Hi,
I need to integrate two stovepipe systems and I need to synchronize a couple of tables between them. There will be two databases running on the same server. There are tables in each database that a similar but not exactly the same, each system monitors changes to it's database and behaves accordingly. What I want to do is put AFTER_UPDATE triggers on these tables and then update their corresponding table in the other database. Here is my concern, if I have an AFTER_UPDATE trigger on both tables I will get into an endless loop. Is there a way to turn off the AFTER_UPDATE triggers only during the trigger updates between the two tables?
Thanks,
John
Subject
Views
Written By
Posted
Synchronizing data between different databases/tables
6224
October 18, 2010 10:52AM
1755
October 21, 2010 01:01PM
2600
October 21, 2010 03:51PM
1835
October 21, 2010 04:22PM
1900
December 04, 2010 09:22PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.