Replication from MSSQL to Oracle database, Replicat ABENDING with OGG-00868 No viable key columns are found for table <username>.<tablename>
(Doc ID 2909704.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 19.1.0.0.4 and laterInformation in this document applies to any platform.
Symptoms
Replication between MSSQL to Oracle using the Golden Gate.
MSSQL is the Source database and destination is oracle database.
At the Oracle end Replication is ABENDING with OGG-00868 Oracle GoldenGate Delivery for Oracle, test.prm: No viable key columns are found for table STAGING.TEST.
TABLE description at MSSQL :-
id
name
url
logo
nav_logo
TABLE description at ORACLE DB :-
Name Null? Type
----------------------------------------- -------- ----------------------------
ID VARCHAR2(32767 CHAR)
NAME VARCHAR2(32767 CHAR)
URL VARCHAR2(32767 CHAR)
LOGO VARCHAR2(32767 CHAR)
NAV_LOGO VARCHAR2(32767 CHAR)
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 |