Replicat Abends with Error OGG-00918 Key Column <Column Name> is Missing from Map
(Doc ID 1958451.1)
Last updated on DECEMBER 27, 2022
Applies to:
Oracle GoldenGate - Version 11.2.1.0.26 and laterInformation 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 |