Re: ** mv versus advanced replication

If you are doing one-way propagation dont even consider advanced replication. If you are doing two way then your only choice is advanced replication, I dont think your choice is based on "How easy is to setup X", rather is what is your requirements.

MV Replication is very easy to setup but bear in mind the limitations and the volume of data you have to replicate. Consider also the interval, hourly, daily?

Regards

On 9/5/06, A Joshi <ajoshi977_at_yahoo.com> wrote:
>
> Hi,
> I have a 250 GB database and need to replicate it with almost all the
> tables. I am thinking of doing MV replication. Other options are advanced
> replication and logical standby. What are pros and cons of using MV as
> opposed to advanced replication. I think some of the maintenance to be done
> is less in case of MVs and it is simpler to understand and setup. Any
> advantages for advanced replication? What about data integrity on target. I
> think advanced replication checks before applying changes so any loss of
> transaction is detected. Is there any check in case of MV? Any tools to
> check the data on target? I think the performance impact degradation on
> source for both is almost same.
> Thanks for your help.
>
> ------------------------------
> Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small
> Business<http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/>.
>
>
>

--
http://www.freelists.org/webpage/oracle-l