New Streams User Having Trouble Setting Up Conflict Resolution
818442Nov 24 2010 — edited Dec 23 2010I have just recently started working with Oracle Streams in 11gR2. I have bi-directional replication working between two databases. Now I am beginning to experiment with Conflict Resolution. I am using a simple table with just three columns (no LOBs). I have tried specifying first DISCARD, then OVERWRITE, and then MAXIMUM (after adding a TIMESTAMP field that gets populated via a trigger). In each case, when I try to commit an insert of the exact same record first in one database and then immediately following in the second database, the APPLY process for each aborts with a uniqueness violation. Does anyone have any idea why the conflict resolution is not doing its job?