Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MV Fast Refresh

479297Oct 17 2007 — edited Oct 17 2007

I want to implement One way replication between master and slave...

I want to use the FAST REFRESH Mechanism...for Fast Refresh, i have to create the Materialized view logs in master database..

if we create materialized view logs in the master database, then space demand will be increased in the master database....
for suppose, if i want to implement the replication for 100 tables...100 Materialized view logs are need to be created in master database...so.it will increase space demanding...

which is the best method of refreshing...

is it FAST or Complete refresh...

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 14 2007

Added on Oct 17 2007

#general-database-discussions

4 comments

319 views