Oracle GoldenGate – using Unique Index instead of Primary Key

Oracle GoldenGate Replicat process requires somehow to identify replicated records. When an UPDATE or DELETE command is replicated the Replicat process needs somehow to identify the row that has to be modified. The obvious solution is to use a PRIMARY KEY on the target table to avoid scanning the whole table to find the row. …

Oracle GoldenGate – using Unique Index instead of Primary Key Read More »