Get the refresh status of Materialized view

How to find when materialized view refresh.


select OWNER,MVIEW_NAME,LAST_REFRESH_TYPE,last_refresh_date,to_char(last_refresh_end_time,'dd-mon-yy hh:mi:ss')from all_mviews;

Comments

Popular Posts