Request propagation (multimaster replication) from trigger?

[yodaa]

I'm looking for information regarding multimaster replication in Oracle 10g. I've found out that asynchronous replication would suit our needs well. The exception is the data conflict that occurs when two users at the same time creates a new record in the exact same table in their local database. For this I'm thinking if it is possible to request propagation of queued data from a trigger that is fired off on when a new post is created? I'm thin that this could eliminate or at least largely minimize the problem of unique key violations on creation of new records in the database. Is it possible to, besides scheduled propagation, also request propagation from a trigger?

Thankful for any answers.

/yodaa

 

[markrem]

Yes, it's possible. That's what Oracle does. Triggers and procedures on each table.

With regards to your question on conflict resolution techniques, why not use the built-in functionality provided by Oracle? For example, define column groups and then for each column group select one of Oracle's pre-defined conflict resolution methods such as preferred node or timestamps.


MarkRem
Author, Oracle Database 10g: From Nuts to Soup

http://www.remidata.com/book_nuts2soup.htm