GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Multimaster Bi-directional Streams PLUS one way Stream to third DB.

edited Dec 2, 2010 4:43AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
 I am sure I will be embarrassed by having missed a simple trick for this. We have been running a bi-directional multimaster Streams between a database in the USA and one in Malaysia for over two years. Now I need to stream the same schema from the OLTP database in the US to a data warehouse instance also in the US. What I encountered was that only the transactions occurring in the US OLTP database were being applied to the US DW instance. Changes made in the Malaysian OLTP instance were applied to the US OLTP but NOT "forwarded" to the

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