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;
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
Post a Comment