Oracle Snapshot Not Working [closed]
- by nayef harb
i have created a snapshot that takes data from 2 tables and has a refresh rate of 1 day.
The snapshot data is not refreshing it is still the same. is there something that i am
missing ?
Here is the code:
CREATE SNAPSHOT test
REFRESH COMPLETE
START WITH SYSDATE
NEXT sysdate + 1
AS
select item_code,item_conc_code,tran_bran_code,sum(tran_qty) bal_qty
from tranhist a,
itemmast b
where a.tran_item_code = b.item_code
group by item_code,item_conc_code,tran_bran_code