ORACLE : Materialized view- change START WITH CLAUSE
It's really quite straightforward.
SQL> create materialized view emp_data 2 as select * from emp 3 /Materialized view created.SQL> ALTER MATERIALIZED VIEW emp_data 2 REFRESH COMPLETE 3 START WITH TRUNC(SYSDATE+1) + 12/24 4 NEXT SYSDATE+1 5 /Materialized view altered.SQL>