My Oracle Support Banner

Handling Tables Without Primary Keys (PK) or Unique Indexes (UI) using KEYCOLS (Doc ID 1379932.1)

Last updated on MARCH 27, 2024

Applies to:

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

Purpose

 This document describes how Oracle  GoldenGate (OGG) works with tables lacking unique keys.

Scope

Helpful information for everybody replicating data without unique keys.

Details

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
Purpose
Scope
Details
 1. Initial loading.
 2. Applications on source machine updating rows without using values from columns, such as using rowid.
 Reason:
 How good are your KEYCOLS columns?
 Performance
 Notes:
References

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