Re: Advanced Replication VS Materialized views

If Database B is read only for users use materialized view instead of Multimaster Replication.
First way is

1. much more simple and reliable in operation
2. much more simple to support, change, upgrade, etc.
3. more independent from Oracle version 
4. faster (much more :)

You need Multimaster Replication if two sites can concurrently update the same data.
So you need conflict resolution and etc...

Marwan Samra wrote:
>
> The question I have is: Should I use Advanced replication, or
> Materialized views and why in the following environment ?
>
> 1- Database A, and Database B:
> - Both are 8.1.7 with advanced replication option.
> - Are on 2 different but connected machines.
>
> 2- Database A: will be used for updates and retrieval.
> (Client/Server).
>
> 3- Database B: - will have less tables than database A, but all other
> tables
> should be exactly the same.
> - Will be read-only database.
> - accessed over the web/public.
>
> Thanks in advance for your help.
>
> Marwan Samara.

-- 
Georgiy Kudryavtsev	Voice:	(095) 787-1316
Teleross			(095) 787-1000
			E-mail:	mailto:georgiy_at_online.ru
			SMS:	mailto:georgiy_at_pagergate.ru