Home » SQL & PL/SQL » SQL & PL/SQL » Doubt in MV refresh
Doubt in MV refresh [message #217725] Mon, 05 February 2007 01:50 Go to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi all
i have a doubt in MV refresh. we have scheduled the refresh in every 10 minutes.what happens if the system fails or the server is bounced back during a MV refresh. When is the time for the next refresh is set. the refresh fails how will it set the next time..


can some one sort it out!!!!!!!!!!!!!!!!!!!!!!!

thanks in advance

[Updated on: Mon, 05 February 2007 03:14]

Report message to a moderator

Re: Doubt in MV refresh [message #217828 is a reply to message #217725] Mon, 05 February 2007 15:24 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
all that stuff is in the documentation - don't take someone else's opinion.
Re: Doubt in MV refresh [message #217865 is a reply to message #217725] Mon, 05 February 2007 22:41 Go to previous message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

ok .thanks for the reply
Previous Topic: Return a ref cursor for a PL/SQL table
Next Topic: how to count columns in table
Goto Forum:
  


Current Time: Sat Dec 10 10:36:03 CST 2016

Total time taken to generate the page: 0.08359 seconds