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: Tue Jun 27 04:10:09 CDT 2017

Total time taken to generate the page: 0.14750 seconds