My Oracle Support Banner

Postgres GG Extract Abends With OGG-25549 Replica Identity Setting For The Processing Table <Table_Name> Is Set To 'DEFAULT' Which Is Not Compatible To Process DELETE operation (Doc ID 2979140.1)

Last updated on JANUARY 08, 2024

Applies to:

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

Symptoms

OGG configured to replicate data from PostgreSQL to Oracle and the Extract configured at the PostgreSQL side is getting Abended with the below error:

2023-08-28 12:15:16 ERROR OGG-25549 Replica identity setting for the processing table <public.table_name> is set to 'DEFAULT' which is not compatible to process DELETE operation.

............

2023-08-28 12:15:16 ERROR OGG-00145 Call to VAMRead returned with error status 16002.

Changes

 

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
Changes
Cause
Solution
References


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