Relative Content

Tag Archive for oraclerefreshmaterialized-views

Is there a way to know how long it has taken for a materialized view refresh to complete?

I have created few materialized views for tables over dblink. When the materialized views were first created it took almost 20+ minutes as the data was huge. So, i would like to know, for further refreshes of these materialized views, how long it has taken for the refreshes to complete. I tried search in web, most of the answers are towards getting the last refresh time.

Oracle Refresh materialized views without base table

What happens when we try to refresh a materialized view in Oracle whose base table doesn’t exist or is dropped accidentally after sometime.
Can we refresh it using any of the methods – fast, force or complete?