This discussion is archived
3 Replies Latest reply: Jan 13, 2012 2:15 AM by hitgon RSS

Replication solutions

834639 Newbie
Currently Being Moderated
Hi,

I got requirement of data to be sync at different locations. One will be the centralized database and other databases are on different locations like three to four locations. So, what would be the best solution in this case Should I use replication, streams or any other third party tool.

Thank you for your cooperation.

Kind Regards,

Adnan Hamdus Salam
  • 1. Re: Replication solutions
    hitgon Expert
    Currently Being Moderated
    Hi,

    I'm using the Oracle streaming since last 2 Year.

    Oracle Streaming is the best oracle replication solution for synchronize the multiple remote databases.

    There are various other alternative as well like Oracle Golden Gate, Oracle Advance Replication, Oracle Materialized Views

    Regards
    Hitgon

    Edited by: hitgon on Jan 11, 2012 2:40 AM
  • 2. Re: Replication solutions
    834639 Newbie
    Currently Being Moderated
    hi hitgon,

    Thank you for your reply. Do you have a complete document to implement oracle streams?

    If yes, can you share it with me.

    I shall be very thankful to you.


    Thank you for your cooperation.


    Kind Regards,

    Adnan Hamdus Salam.
  • 3. Re: Replication solutions
    hitgon Expert
    Currently Being Moderated
    Hi

    Please find the MetaLink Document
    Streams Bi-Directional Setup [ID 471845.1]


    Regards
    Hitgon

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points