My Oracle Support Banner

Replicat Abends with Error OGG-00918 Key Column <Column Name> is Missing from Map (Doc ID 1958451.1)

Last updated on APRIL 09, 2020

Applies to:

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

Symptoms

On : 11.2.1.0.26 version, 1 - Oracle DB backend

When attempting to start the replicat, the following error occurs.

ERROR
-----------------------

WARNING OGG-00869  No unique key is defined for table 'Table_name'. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
Using the following default columns with matching names:    Column1 = Column1, Column2= Column2, Column3 = Column3
The following target columns were not mapped: =
GG_COMMIT_TIME

ERROR OGG-00918 Key column GG_COMMIT_TIME  is missing from map

MAP statement used

 

Cause

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
Symptoms
Cause
Solution


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