Re: 10g - multi-master-replication vs Streams

Curious wrote:
> Hi all,
>
> we are planning to upgrade 9.2.0.8 to 10.2.0.3.
>
> On our old environment we have had four separate instances and multi-master
> replication setup.
>
> Now when moving to 10.2.0.3 there might be a chance to start using Oracle
> Streams. Would it be worth it.

Yes.

> - is it easier to setup

Yes.

> - is it easier to maintain/monitor

Yes.

> - any other benefits using streams

Less time spent evening and weekends at work.

But before choosing Streams explore whether Change Data Capture will work. It is easier to set up and will handle many situations.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org