yxes2013 wrote:Huh? That sentence doesn't make any sense to me.
Yes, standby and dataguard is out since it always need to be down when updated.
So only advance replication uses materialized view, or view logs? what does basic replication uses?What you are referring to as "basic replication" uses materialized views. Advanced replication also uses materialized views. Both would generally use materialized view logs unless you really want to replicate every row in the table every time.
Huh? That sentence doesn't make any sense to me.I mean standby and dataguard are not my choices. :) so they are out of the picture.