title: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP - is this recoverable?
body: <p>I have a table that has 188307430 records.<br>
  It also has partitions.  </p>
  
  <p>above two statements I realized after firing a SELECT on the table    </p>
  
  <pre><code>select * from emp order by created_date;    
  </code></pre>
  
  <p>This caused the above exception related to temp segment in TEMP tablespace.<br>
  So I have multiple questions:<br>
  Is this issue recoverable - i.e will all other users get impacted ?<br>
  or will other selects simply cause Oracle to cleanup the TEMP tablespace ?    </p>