Hi all,

First of all - IANADBA. I'm just a developer / project manager.

Oracle 10.2.0.3 RAC cluster on Intel Linux, ASM on a SAN.

We have a series of instances on our RAC cluster, some of which support
largish 3rd party applications and some "developed in-house" including an
embrionic MIS DW.

Several of these need to exchange data, and currently this is being
achieved using a mix of bulk overnight partial copies and (near real-time,
some delay acceptable) table triggers.

I am keen to investigate the option of shifting to a consolidated approach
using Oracle Change Data Capture (aka Streams).

At some stage in the future we are also unfortunately likely to need to
add a MSSQL database (via Heterogenous Replication?) to this mix.

I've read (and absorbed a fraction of) the Oracle Streams Replication
Administrator's Guide, and think that the configuration option that will
best suit our needs is "Asynchronous AutoLog archive" mode.

Can any Streams-savvy people provide any general advice as to whether I'm
heading down the right or wrong path?

TIA

Geoff M