Check mview status

September 10th, 2012
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')
/
Comments are closed.