extract not capturing updates using filters.
(Doc ID 2123096.1)
Last updated on DECEMBER 23, 2019
Applies to:
Oracle GoldenGate - Version 12.2.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
Inserts and deletes work fine, but no updates are captured:
extract:
GGSCI 15> edit params <extract_name>
EXTRACT <extract_name>
USERID <user_id>, PASSWORD XXXXXX
RMTHOST <host>, MGRPORT 7809
RMTTRAIL <path>
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
GETINSERTS
GETUPDATES
GETDELETES
TABLE table_name
replicat
REPLICAT <replicat_name>
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/<replicat_name>.dsc, PURGE, MEGABYTES 100
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
DBOPTIONS INTEGRATEDPARAMS(parallelism 4)
USERID <user_id>, PASSWORD <pw>
MAP table_name, TARGET table_name;
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 |
Cause |
Solution |