Home » SQL & PL/SQL » SQL & PL/SQL » is a materialized view accessible for queries while it is refreshing?
is a materialized view accessible for queries while it is refreshing? [message #250483] Tue, 10 July 2007 04:18 Go to next message
smora
Messages: 59
Registered: May 2006
Member
Hi

I have a materialized view that refreshes every 5 minutes:

CREATE MATERIALIZED VIEW test_mv
BUILD IMMEDIATE
REFRESH FORCE
NEXT (sysdate + 5/1440)
WITH PRIMARY KEY 
AS
...


Will I be able to query off of this mat view while it is refreshing, or will it hang until the refresh is complete?

Thanks
SM
Re: is a materialized view accessible for queries while it is refreshing? [message #250614 is a reply to message #250483] Tue, 10 July 2007 11:24 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Concepts
http://www.akadia.com/services/ora_materialized_views.html
Previous Topic: PL/SQL wrapper error
Next Topic: partition exchange
Goto Forum:
  


Current Time: Wed Dec 07 06:35:16 CST 2016

Total time taken to generate the page: 0.07174 seconds