GoldenGate Lose Database Definition Record (DDR) Information While Doing Mapping
Last updated on JANUARY 14, 2017
Applies to:Oracle GoldenGate - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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.
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