Check mview status


<br />
select OWNER, MVIEW_NAME, STALENESS, COMPILE_STATE, to_char(LAST_REFRESH_DATE, 'dd/mm/yyyy hh24:mi:ss') from dba_mviews where upper(mview_name) = upper('&matview_name')<br />
/<br />

select OWNER, MVIEW_NAME, STALENESS, COMPILE_STATE, to_char(LAST_REFRESH_DATE, 'dd/mm/yyyy hh24:mi:ss') from dba_mviews where upper(mview_name) = upper('&matview_name')
/