Materialized View Question 1

[heihojin]

I want to write a materialized view to select all the data from a master table but I want the view not to execute until I execute it. Do I still need the parameters START WITH and NEXT? How do I write the view?

 

[HimanB]

Hi,
Yes you can ignore the Start with ... Next clause but later on when you decide to allow refresh you will have to Alter your view to Add Refresh option and Start with..Newxt clause.

Regards
Himanshu