Re: Oracle 10g: Advanced Replication and Streams

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 03 Apr 2006 20:26:35 +0200
Message-ID: <e0rpbn$1vn$1@news5.zwoll1.ov.home.nl>

Anurag Varma wrote:
> Comments below should be qualified with "as of 10g":

> * Streams is more advanced and flexible than Advanced Replication.
> For example: You can replicate a portion of a table in Streams.
> In Advanced Replication you have to replicate the whole table.
> In fact in Streams the structure of the table in the two databases
> can be different also (for example col1, col2 being replicated from
> databaseA and col3, col4 being replicated from databaseB).
Agreeing with all of the rest of your observations, the above simply is not true: Advanced replication supports "horizontal as well as vertical partitioning", that is, some columns, and/or some rows of a table.

It does take a bit of rocket science, indeed.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

I'm a rocket scientist :)

Received on Mon Apr 03 2006 - 13:26:35 CDT