Hello All,
We've Goldengate bi-directional replication between two Oracle Databases.
There are a few tables that don't have any Primary/Unique keys and the table is not in-sync. Some records are unique in DB A and some in DB B.
We're planning to do initial load on them but the problem is the records which are already present on DB B would eventually be inserted again as part of the Initial Load causing duplicate entries.
Our goal is to have the same records at both DBs and we don't lose any data.
We can define KEYCOLS in Extract/replicat, but that won't work on INSERTs. Can you please suggest if there is a way to handle these situations?
DB Version: 12.1.0.2.0
GG Version: 12.2.0.1
Thanks in Advance!
Regards,
Basu