We are on Oracle 8173 on Windows.
I am new to the materialized view (MV) feature of 8i.
I want to create a MV with manual refresh, which I will refresh weekly.
Could someone provide me the query?
Also, then, How will I refresh the MV.
Thanks in Adv.