3 Replies Latest reply: May 17, 2012 11:48 AM by Herndon RSS

    Streams different MVs to Multiple Destinations Using Oracle Streams

    935554
      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 11.2.0.2.0

      The following explains the scenario:

      Source DB: SDB*

      Schema: Repl_schema
      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.

      -----------
      Thanks