I may be missing what the issue is, but assuming
you mean Multi-Master Replication, here's what I would do.
In a session on each database
2. Delete the duplicates using any one of the many
queries people use to do this (you may want to create a non-unique index on
what should be the primary key column before you do this)
3. Create the primary key (after dropping the
4. exec dbms_reputil.replication_on
I have a table under replication and corrupted with
duplicates. I cannot do any update/delete operation on the table since it
needs a primary key. I cannot create a primary key since duplicates exist.
i tried creating index by appending rowid/rownum but no luck. Any way out
of this. Cannot remove the table from replication since that needs quiescing
and cannot quiese right now due to processing that will last another 4 days.
Thanks for help.