title: Oracle. How to refresh materialized view when don`t have enough space on divece
body: <p>I do not have enough practice in a materialized views, and I have a problem right now.
  I have a oracle database with limited disk space.
  There is a data warehouse in it.
  I created a materialized view to get reports from it.
  The materialized view becomes larger, and every night I began to compress the materialized view.
  Suddenly, when the materialized view refreshed, showed an error.</p>
  
  <pre><code>begin
  DBMS_MVIEW.REFRESH('part_sales_mv','?'); 
  end;
  Error report -
  ORA-12008: error in materialized view refresh path
  ORA-12801: error signaled in parallel query server P004
  ORA-01114: IO error writing block to file  (block # )
  ORA-01114: IO error writing block to file 201 (block # 8907)
  ORA-27063: number of bytes read/written is incorrect
  IBM AIX RISC System/6000 Error: 28: No space left on device
  Additional information: -1
  Additional information: 122880
  ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2566
  ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2779
  ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2748
  ORA-06512: at line 4
  12008. 00000 -  "error in materialized view refresh path"
  *Cause:    Table SNAP$_&lt;mview_name&gt; reads rows from the view
             MVIEW$_&lt;mview_name&gt;, which is a view on the master table
             (the master may be at a remote site).  Any
             error in this path will cause this error at refresh time.
             For fast refreshes, the table &lt;master_owner&gt;.MLOG$_&lt;master&gt;
             is also referenced.
  *Action:   Examine the other messages on the stack to find the problem.
             See if the objects SNAP$_&lt;mview_name&gt;, MVIEW$_&lt;mview_name&gt;,
             &lt;mowner&gt;.&lt;master&gt;@&lt;dblink&gt;, &lt;mowner&gt;.MLOG$_&lt;master&gt;@&lt;dblink&gt;
             still exist.
  </code></pre>
  
  <p>Mview partitioned and subpartitioned by range. This is the parametres of my materialized view:</p>
  
  <pre><code>refresh force on demand
  buid  deferred
  
  parallel
  enable row movement
  using default local rollback segment
  enable query rewrite
  </code></pre>
  
  <p>Please help me with your solutions, to resolve my problem. I need to find a way how to refresh mvew with limited disc space.</p>