Re: oralce replication

Dear Frank:

We have setup Oracle Replication in our company, it is MultiMaster Replicaiton but offcourse it is the requirement of our business. If you have option to use Oracle 9i or 10g, then I would suggest that you should go for Oracle Streams, as it is much more advanced then Oracle Replication. I would also suggest that please go through the metalink site for more information.

Regards
Mehmood
Pakistan

Frank van Bortel wrote:
> Moe wrote:
> > Hi everyone
> >
> > I have 150 tables and i want to have them replicated on three sites.
> > two of the sites are running oracle standard edition and one
> > enterprise. What's the best way to do that?.
> > Can anyone tell me what's the advantages/disadvantages of oracle
> > streaming, multimaster replication and master-Materialized View
> > replication.
> >
> > Thanks in advance
> >
> > Moe
> >
> Apart from versions, the choice between multi-master and
> master-slave replication is business wise, not technical.
> Either you have the business requirement to go MM, or you
> don't. If you don't need it, don't use it; it make life
> more complicated, and there is no advantage in using MM
> replication over MS replication, technically.
>
> --
> Regards,
> Frank van Bortel
Received on Sat Jul 02 2005 - 05:32:09 CDT