Materlized view Refresh Interval
Date: 28 Apr 2004 14:55:43 -0700
Message-ID: <6097f505.0404281355.6d0895ac_at_posting.google.com>
Hi,
I have a materialized view in oracle which is a complex view of 4
tables which
create materialized view materialized_sum
refresh complete
Now the problem is the refresh interval...Is there any way I can
specify a fixed refresh interval...What happens is after the first
belongs to different schemas..
start with sysdate
next sysdate+1/24
as
select ano,sno,count(id) assigned,
count(decode(sstno,70,1))completes,count(decode(sstno,75,1)) ftq,
(count(start_date)-count(complete_date))breakoffs
from
tab1,tab2,tab3,tab4
where tab1.id=tab2.id and
tab4.pkey=tab3.pkey
and tab2.fkey=tab3.pkey
group by ano,sno;
I have a dependent job which runs after the view is refreshed....
Any help is greatly appreciated..
Thanks
Arpit
Received on Wed Apr 28 2004 - 23:55:43 CEST