Re: Replication: Specific questions

Diego:

1. It would be desirable to use the same Oracle version in all sites involved in a given replication environment. that is because you are bound to the capabilities of the greatest common denominator, and would have to set the COMPATIBLE init variable to the earliest of the version numbers.
2. The speed at which data gets replicated is based upon your configuration and, of course, quantity of data. You can set it up as synchronous replication where all the sites are replicated to at commit time, and the commit is not finished until all sites have completed succesfully. Or, asynchronous replication allows you to schedule how frequently the DML is sent out to rep sites. You can have that happen once a week, or have the interval so short and the "delay_seconds" parameter long enough to effectively have it constantly attempting replication.
3. There is a lot to it. See: http://technet.oracle.com/doc/oracle8i_816/server.816/a76959/toc.htm

HTH,
Tom Best

Diego <dpafumi_at_usa.net> wrote in message news:8ll4bc$c8n$1_at_nnrp1.deja.com...
> I just started to investigate a little about replication dabatases
> Master to Master.
> I have some specific questions:
> 1- Should I use the SAME oracle version in both sites?
> 2- How fast I can send/receive the data? I mean, suppose that I update
> a row or insert a row in SITE1, how fast that information is going to be
> replicated at SITE2?
> 3- Could you give me some help in how to do point 2
>
> Thanks and if you can, answer me to dpafumi_at_yahoo.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jul 25 2000 - 00:00:00 CDT