-
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
leonard905
leonard905@yahoo.com
-
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
leonard905
leonard905@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|