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: 21148
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: Materialized View
Next Topic: date problem
Goto Forum:

Current Time: Wed Aug 23 05:13:01 CDT 2017

Total time taken to generate the page: 0.10321 seconds