GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Resolve UPDATEINSERTS Unique Key Collision

Hello,

This is a general question for Oracle Golden Gate.

Recently, we encountered Primary Key Collision in our bidirectional setup. We decided to use the UPDATEINSERTS to resolve the primary key collision. Records with ID=1,2,3 were affected.

To resolve the data consistency, we want to replicate records with ID=1,2,3 from Site A to Site B.

Is there a way to replicate thru Golden Gate the affected records?


Thanks!


Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center