how to set automatic referesh for materialized view?
the version of my oracle is 9i.
i have created materialzed view using the following query.
CREATE MATERIALIZED VIEW BALE_STOCK
AS select bale_no,invoice_no,mtrs,rec_dt,batch,mcode,
loc,value from bale_inward where bale_no in(select bale_no from
bale_inward minus select distinct bale_no from bale_outward
select distinct bale_no from bale_gr
select bale_no from(
select bale_no,count(*) from bale_outward group by bale_no
having count(*) > 1
and bale_no in(select bale_no from(select bale_no,count(*) from
bale_gr group by bale_no having count(*) >= 1))))
snapshot is created.
this is not allowing the the options either "fast autofresh on commit"
or "auto refresh on commit".
plz suggest the way to refresh or update this view table automatically
on commiting the source tables of this view.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.