How many rows will be affected by ogg replicat in update/delete when KEYCOLS is in use?
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate - Version 188.8.131.52.20 and later
Information in this document applies to any platform.
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms