determine next refresh time for snapshot

Hi,

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.

Thanks,
L

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
;

Gregg

Thanks. But I looked at all_snapshots and the ones with a refresh_mode of "DEMAND" have blank NEXT columns. Any ideas why?

Thanks,
L