EXCLUDETRANS GGS_REPL to EXCLUDETRANS EXCLUDEONLYFEW in OGG MSSQLSERVER (Doc ID 2120085.1)

Last updated on JULY 17, 2017

Applies to:

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

Goal

In order to configure Bi-Directional replication, I modified EXCLUDETRANS GGS_REPL to EXCLUDETRANS EXCLUDEONLYFEW on both side extracts.

Now IGNOREREPLICAT has lost his functionality, i.e Extract is extracting replicated data as well!!

whereas If I change EXCLUDETRANS back to GGS_REPL then Bi-Directional replication is working fine.

Why can't we modify EXCLUDETRANS from GGS_REPL to EXCLUDEONLYFEW, is this a bug?
 

Solution

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