Replicat Abends with Error OGG-00918 Key Column <Column Name> is Missing from Map

(Doc ID 1958451.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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


On : version, 1 - Oracle DB backend

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


WARNING OGG-00869  No unique key is defined for table 'employee'. 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:    ID = ID, NAME = NAME, SAL = SAL
The following target columns were not mapped: =

ERROR OGG-00918 Key column GG_COMMIT_TIME  is missing from map

MAP statement used



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms