Wednesday, September 12, 2012

Oracle Replications version support

Oracle have several ways to do data replication:
Basic Replication (materialized views),
Advanced Replication (materialized views),
Data Guard,
Streams.

And of course there is also differences between between EE edition and SE edition which replication (and how) you can use:


Basic Replication support both EE and SE


Advanced Replication is EE only.


Data Guard is EE only. (but you can create your on archivelog synchronise scripts for SE standby's)


Streams can be used in SE but only with synchronous capture (this capture only DML and is recommended for only a couple of tables.). If you plan to use Streams for many tables, entire schema or database then you should use capture process which is EE only.


If you decide to do data replication yourself for example with triggers and database link. Then those are available for all editions.

No comments:

Post a Comment