Oracle Database 18c(target)
Oracle Database 12.1.0.2 source
RHEL 7.4
Hello Team,
I am planning to setup a filtering such that XML fields will be omitted
2019-04-04T15:09:16.677+0400 ERROR OGG-01169 Oracle GoldenGate Delivery for Oracle, dwarer.prm: Encountered an update where all key columns for target table CBS_CUST.CB_MULTI_ACCT_RECEIPT_HEADER are not present.
Schema replication is enabled
EXTRACT ECBS
--- User login
USERIDALIAS extractogg
DISCARDFILE ./dirrpt/eapps.dsc, APPEND
DISCARDROLLOVER AT 01:00 ON SUNDAY
EXTTRAIL ./dirdat/et
STATOPTIONS REPORTFETCH
REPORTCOUNT every 10 minutes, RATE
LOGALLSUPCOLS
REPORTROLLOVER AT 01:00 ON SUNDAY
--- DDL Parameters
UPDATERECORDFORMAT COMPACT
TRANLOGOPTIONS INCLUDEREGIONID
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
TABLE CBS_CUST.* ;
EXTRACT extpump
RMTHOST RH-***, MGRPORT 7***
--RMTHOSTOPTIONS ENCRYPT AES192, KEYNAME securekey2
RMTTRAIL /u01/app/OGG/dirdat/rt
PASSTHRU
TABLE CBS_CUST.*;
Should I remove the PASSTHRU in the pump parameter file and include
CBS_CUST.CB_MULTI_ACCT_RECEIPT_HEADER COLSEXCEPT (REQUEST_XML); ?
Thanks,
Joe