My Oracle Support Banner

OGG V21.x Mysql Extract Identifying The Primary Key Columns Incorrectly (Doc ID 2908889.1)

Last updated on JULY 18, 2023

Applies to:

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


Migrated the version of Oracle Goldengate from to to use it with mysql databases. In the last version (19.x) the key
columns were identified correctly but in the new version it doesn't (version
21.x ).

If the primary keys in the table are defined in a different order than columns in the table, the primary keys are not set correctly by Extract.


The issue happens with all 21.x releases lower than


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

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