Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to capture changes of Two Tables and also want to keep TRANLOGOPTIONS EXCLUDEUSER GGS

JamsherApr 14 2020 — edited Jun 18 2020

Hi OGG Gurus,

I have scenario where I need to capture changes of Two Table in Extract which has    TRANLOGOPTIONS EXCLUDEUSER GGS parameter.

DB-A    ----- Unidirectional Replication --- > DB-B <---------Bi Directional Replication ---------> DB-C,D,E,F

These Tables are getting replicated from DB-A to DB-B from Unidirectional Replication

But now I have requirement to Capture these Tables in DB-B and forward to  DB-C,D,E,F which are in Bi Directional Replication with 4 databases

As as a part of Bi Directional Replication I am using parameter TRANLOGOPTIONS EXCLUDEUSER GGS in DB-B , So changes will not be capatured in DB-B

So is there any way I can exclude these two tables in DB-B  from parameter TRANLOGOPTIONS EXCLUDEUSER GGS

I know I can configure DB-A   ------  Unidirectional Replication---------->     DB-C,D,E,F But this will need to create pumps and replicate process which will be unnecessary for two tables

Please suggest.

Best Regards

Jamsher Khan

Comments
Post Details
Added on Apr 14 2020
7 comments
198 views