3 Replies Latest reply on May 17, 2012 4:48 PM by Herndon

    Streams different MVs to Multiple Destinations Using Oracle Streams

      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

      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.