GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

setup a bidirectional replication that includes Sequences

edited Sep 2, 2016 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered ✓

i need to setup a bidirectional replication that includes both DML&DDL ,in it need to replicate sequences i know  that its not supported in bi-directional and to overcome it I will need to create odd values at node and even on other node but that is not applicant for since there is  a dozen of sequences that will be recreated  thus if I excluded the sequence from being replicated from both sides will that effect data consistency ?? and what if a sequence is a part of a primary key ?

Thanks ,

Amira@

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