Re: No future for DB2

From: HansF <News.Hans_at_telus.net>
Date: Mon, 01 Aug 2005 16:46:36 GMT
Message-Id: <pan.2005.08.01.16.50.13.47334@telus.net>

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:

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.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Mon Aug 01 2005 - 11:46:36 CDT