Re: No future for DB2

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@x.washington.edu (replace x with u to respond)