Please use the below query.
SELECT DISTINCT(TRUNC(last_refresh))
FROM dba_snapshot_refresh_times;
select owner, mview_name, last_refresh_type, last_refresh_date
from dba_mviews;
Recommended Posts
Please use the below query.
SELECT DISTINCT(TRUNC(last_refresh))
FROM dba_snapshot_refresh_times;
select owner, mview_name, last_refresh_type, last_refresh_date
from dba_mviews;