This post covers How to Handle Tables Without Primary Keys or Unique Indexes With Oracle GoldenGate, one of the common query that we get frequently from our trainees in our training Oracle GoldenGate 12c Administration.
We have noticed as per our experience during training, there are some of the common queries/issues faced by trainees while they are supporting the Goldengate environment or setting up the new environment. Hence we have come up with a blog series on those common issues/questions and resolution. Here is the first Query:
How to Handle Tables Without Primary Keys or Unique Indexes With Oracle GoldenGate
In order to maintain data integrity when replicating transactional data, Oracle GoldenGate will use primary key columns or unique index columns to uniquely identify a row when issuing update or delete statements against the target database. If no primary keys or unique indexes exist on the table being replicated, Oracle GoldenGate will use all columns to uniquely identify a row.
It is perfectly acceptable to use all columns to uniquely identify a row under the following conditions:
- A logical key column cannot be defined for the table using the KEYCOLS parameter.
- No duplicate rows exist in the table
- Table contains a small number of rows, so full table lookups on the target database are minimal
- Table DML activity is very low, so “all column” table supplemental log groups do not negatively impact the source database redo logs
If the table being replicated does not meet all of the conditions listed above, it is recommended to add a column to the table with an SYS_GUID default value to uniquely identify the row.
This post is from our Oracle GoldenGate 12c Administration Training, in which we cover Architecture, Installation, Configuring & Preparing the Environment, DML Replication – Online Change Synchronization, Initial Load, Zero Downtime Migration & Upgrading using GoldenGate, Oracle GoldenGate Security, Performance of Oracle GoldenGate and Troubleshooting and much more.
If you are just starting out in Cloud then I highly recommend you to go through these posts first
- Oracle GoldenGate 12c Overview & Components
- Oracle GoldenGate 12c Download & Installation
- FAQ’s: Oracle GoldenGate 12c
- Oracle GoldenGate 12c Training : Step by Step Activity Guides /Hands-On Lab Exercise
- Our Course Oracle GoldenGate 12c Administration
Did You Register For FREE GoldenGate Webinar?
NO! So your next task is to get yourself register for our FREE Webinar on Learn Oracle GoldenGate 12c for Replication & Migration to start your Goldengate journey. Click on the image below to register for FREE.
Do you have any queries in Oracle GoldenGate 12c? please reach out to us at firstname.lastname@example.org