title: Insert into table, from view, Oracle, unable to extend temp segment
body: <p>I have the following code in Oracle:</p>
  
  <p>insert into table_x<br>
      select * from view_y;
  commit;</p>
  
  <p>where view_y takes about half an hour to execute and returns about 400 000 records. </p>
  
  <p>The problem is when I try to make the insert. The insert takes more than two hours and now it even can't get finished. 
  The error is "Unable to extend temp segment by 64 in tablespace TEMP". </p>
  
  <p>Please advice on another way to insert the data - from view into the table. </p>
  
  <p>Thanks much! </p>