I have materialized view for which i want to alter its refresh time:
REFRESH FORCE START WITH SYSDATE NEXT SYSDATE +1 DISABLE QUERY REWRITE
I want to know few things in this.
- What does
NEXT SYSDATE +1depict?
- How am I going to change it (e.g after every 6 hours)?
- What is
DISABLE QUERY REWRITE?