My Oracle Support Banner

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 later
Information 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


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