My Oracle Support Banner

How many rows will be affected by ogg replicat in update/delete when KEYCOLS is in use? (Doc ID 1907881.1)

Last updated on FEBRUARY 13, 2020

Applies to:

Oracle GoldenGate - Version 11.2.1.0.20 and later
Information in this document applies to any platform.

Goal

We know that when PK/UI is in use, when replicat replicates update/delete, it will base on the key column values.

When there is no PK/UI, the update/delete will base on all the column, and 'and rownum=1' is added to make sure it affects only one row.

Now the question is if we use keycols in above 2 scenarios, will it affect if  'and rownum=1' will be added or not?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.