GoldenGate Lose Database Definition Record (DDR) Information While Doing Mapping (Doc ID 2171749.1)

Last updated on JANUARY 14, 2017

Applies to:

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

Goal

If we do the following mapping
table ORCL.GGTEST.EMPLOYEES, target GGTEST.EMPLOYEES; then GoldenGate Pump lose DDR information in the downstream trail.
Although table ORCL.GGTEST.EMPLOYEES; works just fine.

You will see that local  trail file dirdat/bb000000000 will contain correct DDR record (see pa_DDR.txt). For example Character set is UTF8
--------Character set ID: UTF-8----------
This is correct because source trail was created using UTF8 database.

However remotetrail  file   dirdat/bb000000000 will contain incorrect DDR record (see pb_DDR.txt). For example Characted set is "default" (look like this is CP1252)
--------Character set ID: default----------
This is incorrect and it leads to problem: downstream replicat interpret trail file as CP1252.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms