Home » SQL & PL/SQL » SQL & PL/SQL » matrialized
matrialized [message #223754] Sun, 11 March 2007 00:06 Go to next message
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
Messages: 20848
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: Fri Oct 21 06:37:09 CDT 2016

Total time taken to generate the page: 0.12790 seconds