Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Site Priority Conflict Resolution

arnelcJan 14 2007 — edited Jan 17 2007

I'm using Oracle9i version 9.2.0.1.0 running in Windows Server 2003

I am testing Materialized View Replication ( 1 Master site and multiple
materialized view site) for my Advanced Replication setup. To resolve
conflict I employ Site Priority Conflict Resolution Method.

I successfully pushed data from mview site-1 to the master site.

When I pushed data from mview site-2 to the master site with the same
data previously pushed from mview site-1, unique constraint is violated
hence a failure in replication. It seems my conflict resolution is not
working. Can anybody help me resolve my problem?

Arnel

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 14 2007

Added on Jan 14 2007

#database-key-features, #replication

6 comments

1,533 views