Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Since I see that it is possible to specify an expression like sysdate + 1, here are my questions:

  • Is it possible to specify the exact time of the refresh for materialized views in oracle?

  • Is it possible that it all starts at 2 a.m. while there is nobody using the db from my application?

share|improve this question
up vote 8 down vote accepted

Your expression can be as complicated as you'd like so you can certainly specify that the refresh should happen every day at 2 AM, i.e.

NEXT trunc(sysdate+1) + interval '2' hour

will specify that the refresh happens every day at 2 AM. The expression is evaluated at the conclusion of each refresh so you just need to ensure that the expression evaluates to whatever time you want at that particular instant in time.

share|improve this answer
thanks! Do you perhaps know the answer to my other quesion:… – paweloque Mar 24 '11 at 16:28
@lewap - Just posted a reply over there. – Justin Cave Mar 24 '11 at 16:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.