Re: Replication..

Yep - advanced replication is updateable snapshots and master-to-master replication, whereas basic replication is read-only snapshots (known these days as materialized views). And here's the reply from Dominic Delmolino regarding versions:

Hey Mogens!  

I'll be seeing you at the conference -- bring me an ice-cold bottle of Denmark's finest akvavit.

No, wait, that was the wrong one. Sorry. Here's the one I was thinking about...

Advanced replication was introduced in 7.1.6

Best regards,

Mogens

Richard Ji wrote:

>My understanding is that Basic replication is "readonly snapshot".
>Anything above that, including updatable snapshot is advanced replication.
>
>Richard
>
>-----Original Message-----
>Sent: Wednesday, January 29, 2003 4:24 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Paul - That is not my understanding. If you look in the Oracle guide that
>shows the differences between Standard Edition and Enterprise Edition,
>Standard has something named "Basic Replication", and Enterprise has
>"Advanced Replication". Advanced means multimaster replication. Basic means
>snapshots. In between there are several other replication alternatives, like
>updatable snapshots, but I haven't seen a clear explanation of where basic
>stops and advanced starts. If anyone knows, I would appreciate their posting
>the facts.
>
>Dennis Williams
>DBA, 40%OCP
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>
>
>-----Original Message-----
>Sent: Wednesday, January 29, 2003 2:59 PM
>To: Multiple recipients of list ORACLE-L
>
>
>I believe that "Advanced Replication" was just a name change,
>introduced in either Oracle8 or Oracle8i.
>
>PB
>--- Mogens_Nørgaard <mln_at_miracleas.dk> wrote:
>
>
>>The person I know who can answer this is the guy who was Mr
>>Replication
>>in Cary's SPG-group from the beginning, namely Dominic Delmolino. He
>>was
>>truly a pioneer with that stuff. I'll ask him and get back.
>>
>>Mogens
>>
>>DENNIS WILLIAMS wrote:
>>
>>
>>
>>>Chaim - I agree with your note, but isn't that basic replication?
>>>
>>>
>>Robert
>>
>>
>>>asked about advanced (multimaster) replication.
>>>
>>>Dennis Williams
>>>DBA, 40%OCP
>>>Lifetouch, Inc.
>>>dwilliams_at_lifetouch.com
>>>
>>>
>>>-----Original Message-----
>>>[mailto:Chaim.Katz_at_Completions.Bombardier.com]
>>>Sent: Monday, January 27, 2003 2:12 PM
>>>To: Multiple recipients of list ORACLE-L
>>>
>>>
>>>
>>>
>>>
>>>from metalink note: 28018.1
>>
>>
>>>5.14 Symmetric Replication
>>>
>>>---------------------------
>>>
>>> The Oracle symmetric
>>>
>>>replication facility is new with
>>>
>>>release 7.1.6. The symmetric
>>>
>>>replication facility allows
>>>
>>>multiple copies of data to be
>>>
>>>maintained at different sites in
>>>
>>>a distributed environment. It
>>>
>>>provides immediate, local access
>>>
>>>to data and allows systems to
>>>
>>>function autonomously even when
>>>
>>>other systems in the distributed
>>>
>>>environment are unavailable, or
>>>
>>>networks fail. To use the
>>>
>>>symmetric replication facility,
>>>
>>>you must have purchased and
>>>
>>>installed the replication
>>>
>>>option. The symmetric
>>>
>>>replication facility is
>>>
>>>documented in the "Oracle7
>>>
>>>Server Distributed Systems:
>>>
>>>Replicated Data" manual.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>Freeman Robert - IL <FREEMANR_at_tusc.com>@fatcity.com on 01/27/2003
>>>
>>>
>>02:29:24
>>
>>
>>>PM
>>>
>>>Please respond to ORACLE-L_at_fatcity.com
>>>
>>>Sent by: root_at_fatcity.com
>>>
>>>
>>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>>cc:
>>>
>>>
>>>
>>>Any of you Oracle history buffs remember what version of Oracle that
>>>advanced replication was first available in?
>>>
>>>RF
>>>
>>>Robert G. Freeman
>>>Technical Management Consultant
>>>TUSC - The Oracle Experts www.tusc.com
>>>904.708.5076 Cell (it's everywhere that I am!)
>>>Author of several books you can find on Amazon.com!
>>>--
>>>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>>--
>>>Author: Freeman Robert - IL
>>> INET: FREEMANR_at_tusc.com
>>>
>>>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>>>San Diego, California -- Mailing list and web hosting
>>>
>>>
>>services
>>
>>---------------------------------------------------------------------
>>
>>
>>>To REMOVE yourself from this mailing list, send an E-Mail message
>>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>>>the message BODY, include a line containing: UNSUB ORACLE-L
>>>(or the name of mailing list you want to be removed from). You may
>>>also send the HELP command for other information (like subscribing).
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>--
>>Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
>> INET: mln_at_miracleas.dk
>>
>>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>>San Diego, California -- Mailing list and web hosting services
>>---------------------------------------------------------------------
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>>the message BODY, include a line containing: UNSUB ORACLE-L
>>(or the name of mailing list you want to be removed from). You may
>>also send the HELP command for other information (like subscribing).
>>
>>
>>
>
>
>__________________________________________________
>Do you Yahoo!?
>Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
>http://mailplus.yahoo.com
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_MiracleAS.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).