determine next refresh time for snapshot
How can I find out the next refresh date for a materialized view that is refreshed forced on demand. The materialized view was created using build immediate. The data dictionary view MVIEWS mentioned only last refresh time which in this case is the same as the date I created the materialized view.
SQL Script ... Run from SQLPlus
set linesize 100
select substr(s.name,1,20),error,refresh_method,fr_operations "Fast Refresh",
cr_operations "Complete Refresh",type,
to_char(t.last_refresh,'DD-MON-YY HH24:MI:SS') "Next Refresh"
from all_snapshots s, all_snapshot_refresh_times t
where type = 'FAST'
and s.name = t.name
order by t.last_refresh desc
Thanks. But I looked at all_snapshots and the ones with a refresh_mode of "DEMAND" have blank NEXT columns. Any ideas why?
Click Here to Expand Forum to Full Width