title: DBMS_Snapshot.refresh not working on 11g , materialized view error
body: <p>I executed <code>DBMS_Snapshot.refresh</code> on <code>Oracle 10g</code> it worked fine, but when i execute the same on <code>Oracle 11g</code> it gives the following error</p>
  
  <pre><code>DBMS_SNAPSHOT.refresh('Table1','F'); 
  
   BEGIN DBMS_SNAPSHOT.refresh('Table1','F'); END; 
   . 
   *
  
   ERROR at line 1: 
   ORA-23401: materialized view "localuser"."Table1" does not 
   exist 
   ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2558 
   ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2771 
   ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2740 
   ORA-06512: at line 1
  </code></pre>
  
  <p>Any help much appreciated</p>
  
  <p>Regards.</p>
  
  <p>Nandish</p>