Database Software

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!

updatable materialized views

ExorSep 6 2012 — edited Sep 9 2012

Hello,

I have 6 updatable materialized views that did not refresh in 6 months. Even though the table has 12k records the mlog has 1.000.000 entries. needless to say when i try to fast refresh it hangs forever. What can I do to refhresh and not loose the changes on either side?
Would a complete refresh of updatable mview will perform both way replication? What if since the last refresh the same field was updated in both envs? Which one will prevail?

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 7 2012

Added on Sep 6 2012

#database-key-features, #replication

8 comments

4,114 views