hi,

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
union
select distinct bale_no from bale_gr
minus
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.