Home » SQL & PL/SQL » SQL & PL/SQL » Querying a materialized view while its refresh is on.
icon4.gif  Querying a materialized view while its refresh is on. [message #413256] Wed, 15 July 2009 00:54 Go to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

Hi All,

Consider I have a materialized view and I had initiated the refresh for this materialized view.

Now when I try to execute a procedure that accesses this materialized view, this procedure was running indefinitely.

Is there any way to avoid simultaneous execution of overlapping jobs?

regards,
Nataraj
Re: Querying a materialized view while its refresh is on. [message #413263 is a reply to message #413256] Wed, 15 July 2009 00:59 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dbms_lock
dbms_alert

Regards
Michel

Previous Topic: Getting Error with Cross join query
Next Topic: date in varchar column
Goto Forum:
  


Current Time: Tue Dec 06 04:20:22 CST 2016

Total time taken to generate the page: 0.33438 seconds