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!

MVIEW Refresh

581574Jul 2 2008 — edited Jul 3 2008

We have many materialized views(MV) in our DB which would take 30 min. approx to refresh, we 're using DBMS_SNAPSHOT.REFRESH to refresh the MVs.

I can see that there is a package DBMS_MVIEW.REFRESH available for MV refresh itself.

Can you please let me know which is advantageous and how?

Thanks,
Santhosh

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 31 2008

Added on Jul 2 2008

#general-database-discussions

7 comments

717 views