Goldengate replicates DDL to add new column but not the data
edited Aug 25, 2016 4:15PM in GoldenGate, Streams and Distributed Database (MOSC) 12 commentsAnswered
We are using Oracle GoldenGate 11.2.1.0.22 to replicate between two Oracle 11Gr2 databases. We have DDL replication enabled and when we add a new column to a table on the source database the DDL gets replicated to the target database. However, when data is added to the new column on the source table, it does not show up in the target table. This happens for both Insert and Update records.
Has anybody else experienced this issue?
Something interesting that I did come across is that I tried specifying a column mapping in the extract parameters file:
table MTSPROD.GG_TEST_01, COLS(COL1,COL2,COL3)
1