Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Request propagation (multimaster replication) from trigger?

Request propagation (multimaster replication) from trigger?

From: yoda <syrianska_at_hotmail.com>
Date: 16 Mar 2006 10:05:50 -0800
Message-ID: <1142532350.192405.233960@i40g2000cwc.googlegroups.com>


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.

/yoda Received on Thu Mar 16 2006 - 12:05:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US