Update Trigger for Replication
Posted on 2003-10-24
I am a german student writing his thesis on distributed databases. The actual DB is an Oracle 9i Enterprise Edition Release 2.
I have one table, that should be maintained on all sites. It would need updating "on commit", regardless if a new record is inserted, updated or deleted. Each site should get its own trigger, so that updates/inserts/deletes are possible on every site, with immediate replication on the other sites. However, mutations on this particular table are rather seldom, that's why I chose "triggers" over "advanced replication". I am looking for a more robust, potentially asynchronous solution.
Anything could help me ;-)