Hi,
Goldengate extract process extract null values for primary key column. Due to FORMATASCII parameter in extract, I' am able to read context of trail file.
Here my extract parameter file:
EXTRACT EXTXXX1
TRANLOGOPTIONS ALTARCHIVELOGDEST $arc_path
TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT $arc_pattern.arc
SETENV (ORACLE_SID="ORASID")
SETENV (ORACLE_HOME = "ORA_HOME")
USERID gg, PASSWORD ****************, AES128, ENCRYPTKEY *********
-- Just in case we can't process a record we'll dump info here
DISCARDFILE $GG_HOME/dirrpt/EXTXXX1.dsc, PURGE, MEGABYTES 10
REPORTROLLOVER on sunday
FORMATASCII
EXTTRAIL $GG_HOME/dirdat/ex
TABLE SCHEMA.MY_TABLE;
ddl exclude all
And also, here my trail file context:
V,B,SCHEMA.MY_TABLE,MY_PRIMARY_KEY_COLUMN,NULL,UPDATE_COLUMN,'2020-12-23:13:19:22'
V,A,SCHEMA.MY_TABLE,MY_PRIMARY_KEY_COLUMN,NULL,UPDATE_COLUMN,'2020-12-23:13:19:22'
As you can see, subsequent values after MY_PRIMARY_KEY_COLUMN is null. How can manage them?
Extract is in classic capture mode(Thinking of to upgrade it to integrated capture).
My GoldenGate information:
Oracle GoldenGate Command Interpreter for Oracle
Version 12.3.0.1.4 OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBO
Database version:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0
PL/SQL Release 12.2.0.1.0 - Production 0
Thanks in advance:)!