Hi All ,
A requirement has come up where i would be needing to stream over materialized views(MVs) in one schema on the source DB to multiple destination databases using oracle streams_.
We will be using 188.8.131.52.0
The following explains the scenario: Source DB: SDB*
MVs: MV1,MV2,MV3 Destination DB: DDB1, DDB2, DDB3*
Now MV1 has to go to DDB1, MV2 has to go DDB2 and MV3 has to go to DDB3.
Is the above possible with one source DB and multiple destination DB? It would be really helpful if a high level architecture can also be provided for the same.
Just to understand your requirement , are all three MV1 , MV2 and MV3 materialized view sites pointing to SDB database ?
Now what is the relation between SDB and DDB* databases?
MV1, MV2 and MV3 all are in Source DB i.e. "SDB" under schema "MS_Schema".
The above three MVs need to be streamed over to different destination DB i.e DDB1, DDB2 and DDB3 using oralce Stream.
My Question is whether it is possible to Stream as follow:
MV1 to DDB1
MV2 to DDB2
MV3 to DDB3
I think we can use hub-spoke mechanism for this type of stream but not sure if different things can from the source DB can be streamed to different destination DBs.