title: Create temporary tablespace using a query to determine size in Oracle
body: <p>I'm trying to create a temporary tablespace that would be half the size the 'TEMP' tablespace.</p>
  
  <p>So something like :</p>
  
  <pre><code>create temporary tablespace Temptest
  TempFile 'somepath'
  size ?M;
  </code></pre>
  
  <p>where ? = </p>
  
  <pre><code>select bytes/2/1024/1024 
    from dba_temp_files 
   where tablespace_name='TEMP';
  </code></pre>