Hi Guys,

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.