Home » SQL & PL/SQL » SQL & PL/SQL » matrialized
matrialized [message #223754] Sun, 11 March 2007 00:06 Go to next message
getritesh
Messages: 235
Registered: July 2006
Location: INDIA
Senior Member

How does the clause

Refresh on demand
while creating materialized view work practically?
Re: matrialized [message #223774 is a reply to message #223754] Sun, 11 March 2007 05:28 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just like its name says - materialized view will not refresh until you explicitly say so (i.e. unless you demand it), using
EXECUTE dbms_mview.REFRESH('materialized_view_name');

Read more about how to create a materialized view; you'll find the ON DEMAND clause too.
Previous Topic: multiple rows
Next Topic: Materialized View
Goto Forum:
  


Current Time: Sat Dec 10 20:18:38 CST 2016

Total time taken to generate the page: 0.10488 seconds