title: How to increase the TEMP TABLE Space value in Oracle?
body: <p>Currently  my Oracle 11g  temp TABLESPACE value is  34GB. I need to increase the table space value to a large value (45GB)</p>
  
  <p>I tired the following sql command to increase the temp table space.</p>
  
  <pre><code>    ALTER TABLESPACE temp ADD TEMPFILE '/oradata/temp01.dbf' SIZE  45G
  </code></pre>
  
  <p>The error:</p>
  
  <blockquote>
    <p>SQL Error: ORA-01144: File size (5536951 blocks) exceeds maximum of
    4194303 blocks
    01144. 00000 -  "File size (%s blocks) exceeds maximum of %s blocks"
    *Cause:    Specified file size is larger than maximum allowable size value.
    *Action:   Specify a smaller size.</p>
  </blockquote>
  
  <pre><code>    SELECT value FROM v$parameter WHERE name = 'db_block_size';
  </code></pre>
  
  <p>The  "db_block_size" value is 8192</p>
  
  <ol>
  <li>How do I decide the maximum allowed db_block_size and the corresponding temp TABLESPACE value</li>
  <li>How do I increase the TEMP tablespace?</li>
  </ol>