title: ORACLE : Materialized view- change START WITH CLAUSE
body: <p>I created a Materialized view using the following code:</p>
  
  <pre><code>CREATE MATERIALIZED VIEW M_USER_HIERARCHY 
  
  BUILD IMMEDIATE
  REFRESH COMPLETE
  START WITH TO_DATE('25-Aug-2009 10:34:24','dd-mon-yyyy hh24:mi:ss')
  NEXT SYSDATE + 1     
  WITH PRIMARY KEY
  AS 
  SELECT   * FROM V_USER_HIERARCHY;
  </code></pre>
  
  <p>However, I want to be able to change the START WITH date AFTER this code has been executed.
  I have been looking into the ALL_MVIEW_* tables but could not find where the setting for the START_DATE is.</p>
  
  <p>Does anyone know how to change the START_WITH date of a Materialized View ?</p>