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;

Share this post
Recommended Posts

Leave a Comment

Start typing and press Enter to search