title: Error creating a duplicate table in oracle
body: <p>I wanted to create the copy of a table using the following sql command in oracle:</p>
  
  <pre><code>create table table_backup as select * from paper_search;
  </code></pre>
  
  <p>I encountered the error like this</p>
  
  <pre><code> [Err] ORA-01652: unable to extend temp segment by 8192 in tablespace
  </code></pre>
  
  <p>Since the table paper_search is 20GB of size. I googled and found increasing the TEMP memory size in oracle but I have no idea how to solve this any suggestion will be highly appreciated.</p>