extract not capturing updates using filters.

(Doc ID 2123096.1)

Last updated on APRIL 08, 2016

Applies to:

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

Symptoms

Inserts and deletes work fine, but no updates are captured:

extract:
GGSCI  15> edit params extora2
EXTRACT EXTORA2
USERID C##FEB, PASSWORD XXXXXX
RMTHOST 10.24.223.56, MGRPORT 7809
RMTTRAIL ./dirdat/rt
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
GETINSERTS
GETUPDATES
GETDELETES
TABLE pdbwms12.C##FEB.REAL_CASE, COLS ( CASE_ID ,DSCR, FILE_DT, CASE_CD ), FILTER(@STRFIND(site_id,'1225')>0), FILTER (ON UPDATE, ON DELETE, ON INSERT, @COMPUTE (@DATE('JUL', 'YYYY-MM-DD', FILE_DT) >= @DATE('JUL', 'YYYY-MM-DD', '2016-01-01')) > 0);

replicat

REPLICAT REPORA2
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/repora.dsc, PURGE, MEGABYTES 100
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
DBOPTIONS INTEGRATEDPARAMS(parallelism 4)
USERID repuser2@pdbdbt03, PASSWORD change1t
MAP pdbwms12.C##FEB.real_case, TARGET pdbdbt03.C##FEB.real_case;

Cause

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