title: ORACLE : Materialized view not working when Using LEFT JOIN
body: <p>I want to create a MATERIALIZED VIEW from a LEFT JOIN of 2 tables. However the following gives me an error:</p>
  
  <pre><code>    SELECT field1 
       FROM table_1 a 
       LEFT JOIN table_2 b 
       ON a.field1=b.field2
  </code></pre>
  
  <p>ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view</p>
  
  <p>However the following works:</p>
  
  <pre><code>SELECT field1 
   FROM table_1 a, table_2 b 
   WHERE a.field1=b.field2
  </code></pre>
  
  <p>Does anyone have any ideas why this is happening.</p>
  
  <p>Thx for the help</p>