GoldenGate update of columns excluded with colsexcept produces trail files anyway
Hello everyone,
I have set a unidirectional replication between two Oracle databases using Oracle GoldenGate 12.
The extract process is configured in order to exclude two columns using the following parameters:
EXTRACT EXTTST
SETENV (NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P1")
USERID xxxxxx, PASSWORD xxxxxx
--Added for IE
LOGALLSUPCOLS
EXTTRAIL ./dirdat/xx, , FORMAT LEVEL 3
TRANLOGOPTIONS INTEGRATEDPARAMS(_CKPT_RETENTION_CHECK_FREQ 3600)
TRANLOGOPTIONS INTEGRATEDPARAMS (_LOGMINER_READ_BUFFERS 256)
GETUPDATES
GETDELETES
GETINSERTS
TABLE schema.tableName, COLSEXCEPT(col1, col2);
and, moreover, the following commands were executed in order to add the process:
ggsci> DBLOGIN USERID xxxx, PASSWORD xxxx
ggsci> ADD schema.tableName ALLCOLS
ggsci> register extract EXTTST DATABASE