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?