Click here to Skip to main content
15,064,140 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i 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
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900