Re: Oracle 10g: Advanced Replication and Streams

Frank van Bortel wrote:
> 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 :)

Thanks to all, guys.

I worked on Oracle 8.1.6 Advanced Rep before. Probably I was lucky or the environment was simple, the setup was easy (I am NOT a rocket scientist). But the maintenance was really stupid, and the rep process was SLOW. Received on Mon Apr 03 2006 - 14:40:02 CDT