GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

GoldenGate update of columns excluded with colsexcept produces trail files anyway

edited Feb 25, 2020 4:58AM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center