HansF wrote:
> On Mon, 01 Aug 2005 00:10:29 -0700, Noons interested us by writing:
>
>
>>DA Morgan wrote:
>>
>>>Madison Pruet wrote:
>>>
>>>>I didn't know that Oracle replication was available on the standard edition.
>>>>I thought that it was only available on the enterprise edition. Am I
>>>>mistaken?
>>>
>>>1. Please don't top post.
>>>2. You are correct.
>>
>>He's correct in that he's mistaken. Snapshot replication
>>(basic replication) *is* available in Standard Edition, 9i.
>>Advanced replication (master2master) is only in EE.
>>10g might have changed that, but that will be another
>>reason for people not to upgrade...
>
>
> Just to expand on that a bit:
>
> a) from the Oracle9i R2 New Features manual:
>
> -----------------
> Basic replication - SE and EE
>
> Oracle9iserver fully supports bi-directional replication with automated
> conflict detection and resolution. Supported configurations include a
> single updatable master site with multiple updatable or read-only snapshot
> sites.
>
> Advanced Replication - EE only
>
> Advanced replication includes basic replication functionality plus
> multi-master replication, Replication Manager, and parallel propagation to
> maximize throughput. (Advanced Replication was formerly known as
> Replication.)
> -----------------
>
> b) from the OracleŽ Database Licensing Information manual for 10g
>
> -----------------
> Advanced Replication (multimaster) - EE only
>
> Basic replication (which is available with Standard Edition and Standard
> Edition One) provides support for read-only and updatable materialized
> views (for replication) and multitier materialized views. Standard Edition
> and Standard Edition One databases can also act as a master site for
> materialized views, but cannot participate in multimaster replication.
> -----------------
Thanks.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Aug 01 2005 - 12:05:04 CDT
