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:

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

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