Re: No future for DB2

"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:1122880229.362562.321330_at_o13g2000cwo.googlegroups.com...
>
> 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...
>

Noons,

Does Oracle snapshot replication

1. replicate all of the trigger activity performed on the original table
2. distinguish between updates on a row and inserts/deletes on the same row? (If not, then cascade deletes are not properly performed)
3. properly handle cascading updates

This is why I generally don't consider snapshot copies as being replication. They generally only replicate the data, and not the engine logic associated with the base table. Received on Mon Aug 01 2005 - 09:48:08 CDT