title: Refreshing MVIEW is throwing a "table or view does not exist"
body: <pre><code>exec dbms_mview.refresh( 'TEST_MVIEW', method=&gt;'C',atomic_refresh=&gt;false)
  
  Error report -
  ORA-00942: table or view does not exist
  ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2821
  ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3058
  ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3017
  ORA-06512: at line 1
  00942. 00000 -  "table or view does not exist"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>The select query that is used for creating the MVIEW is working fine. Based on the answers from a thread, i have compiled the view as well. still the problem persists.</p>
  
  <p>Can someone help me with this?</p>