Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

1 Answer

up vote 5 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: dba.stackexchange.com/questions/1894/… –  paweloque Mar 24 '11 at 16:28
    
@lewap - Just posted a reply over there. –  Justin Cave Mar 24 '11 at 16:29
add comment

Your Answer

 
discard

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.