Replication of an entire schema using Streams

From: Sanjay Mishra <sanjay_mishra0_at_yahoo.com>
Date: Mon, 19 Jul 2004 12:40:32 -0700 (PDT)
Message-ID: <20040719194033.66709.qmail@web14524.mail.yahoo.com>

I am involved in a project which may require setting up streams replication of an entire schema (approximately 500 tables, 50 GB of data, and 50 to 100 transactions per minute) between two databases that are physically located in geographically disparate areas. The replication has to be both ways.  

I would like to have feedback from the members on the following:  

1. Known issues with streams replication on such a scale.
2. Issues with conflict resolution.
3. If I have an Option of selecting 9i vs 10g for Streams, I would pick 10g, because it is much more easier to setup and manage Streams on 10g. However, would like feedback if anyone has experienced any specific issues on either 9i or 10g while managing Streams replication on a such a large scale.

Thanks in advance,
Sanjay Mishra                 

---

Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Mon Jul 19 2004 - 14:39:02 CDT