DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Oracle Streams Replication

  1. #1
    Join Date
    Apr 2007
    Posts
    2

    Oracle Streams Replication

    Hi,
    I have a plan to set up streams replication environment for my company.
    Does anyone has sample scripts for creating positive or negative rule set? Thanks a lot.

    fan

  2. #2
    Join Date
    Jun 2006
    Posts
    259
    Better techniques are available for replication.

  3. #3
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    I would not agree here.
    At least I like streams and if we speak about the old way of replication, using jobs then I would prefer streams

  4. #4
    Join Date
    Apr 2007
    Posts
    2

    Dba

    Hi,
    Thanks for your reply, but what is difference between Streams replication and Multimaster site replication? Thanks.

    fan

  5. #5
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Totally different mechanism, ideology.... only the purpose is similar

  6. #6
    Join Date
    Nov 2008
    Location
    San Francisco
    Posts
    1

    Exclamation My streams opinion

    Hello, using streams vs symmetrical replication needs to be considered. In general with 10g and 11g you are better of with streams. However if you only need to replicate few tables and one way only - why bother with streams -
    go with simple snapshots/matviews. Tell me the business task you are trying to achieve and I will advise you on the best approach.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width