RE: Oracle Replication Product

From: Jared Still <jkstill_at_bcbso.com>
Date: Thu, 16 Nov 2000 08:38:19 -0800 (PST)
Message-Id: <10682.122267@fatcity.com>

On Wed, 15 Nov 2000, Shawn Ferris wrote:

> However, I was lead to believe Sybase's replication on Oracle was superior
> due to the fact that it read from the logs. (I'd never used it and since it
> wasn't originally a Sybase product, it sounded reasonable.)
>
> In the same argument, they say Oracle's replication sucks because it's
> trigger based.
>
> Let it be known that Sybase replication "SIMULATES" Sybase transaction logs
> in Oracle via, none other than, TRIGGERS! 8)

Shawn,

I know that Sybase uses triggers for it's Oracle replication.

Even so, it is still asynch. Oracle replication requires a 2 phase commit; major headache.

Do you want to replicate to more than one database?

Use Sybase Rep Server. It is a very powerful product. Oracle replication cannot even come close to it.

This may change with 9i though. I understand that replication will be reading the redo logs, which will allow for asynchronous operation.

We'll have to wait and see if Oracle knows how to do this well. Received on Thu Nov 16 2000 - 10:38:19 CST