GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

goldengate not replicating UPDATE statement

edited Apr 15, 2016 5:05AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered ✓

Hello.....


I am setting up an environment with Golden Gate and replication is almost perfect all, however, is not replicating queries updates. All other DML commands are carried out successfully.


I test send the table with data and without them and none of these were successful. Follow the informations:

Extract:

extract ext_sgu

SETENV  (NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15)

Set environment variable (NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15)

userid ggate, password **********

rmthost cealrfrisdbe2e, mgrport 7809

rmttrail /oracle/ogg/dirdat/lt

tableexclude ADMSGU.SG115T_USUARIO_EXTERNO_DB2;

tableexclude ADMSGU.SG117T_USR_GRU_RFS;

tableexclude ADMSGU.SG124T_PFL_USR_INTR;

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