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!

materialized view complete refresh much slower than recreate

893411Mar 27 2012 — edited Mar 27 2012

hi!

we are using materialized view for our DWH, which we refresh daily on demand and full. I notice that after some time refreshing the materialized view takes very long (1h), while recreating the materialized view and refreshing it at the same time just takes some minutes. The result ist exactly the same.
Can someone explain me why this is the case? And is there a better way to recreate the materialized view than copying and executing the entire SQL statement?

thanks for your help!

Edited by: 890408 on Mar 26, 2012 11:29 PM

This post has been answered by Hemant K Chitale on Mar 27 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2012

Added on Mar 27 2012

#general-database-discussions

11 comments

5,377 views