title: Oracle spool location
body: <p>I'm using SQL Developer to spool the DDL for some packages, but I cannot identify the location where the server is spooling. Oracle is installed on AIX, but I don't know the user it's using  to connect to the OS.</p>
  
  <p>Basically, when I run:</p>
  
  <pre><code>spool test.lst
  
  select 1 from dual;
  
  spool off
  </code></pre>
  
  <p>I get a confirmation message in console </p>
  
  <pre><code>1                      
  ---------------------- 
  1          
  </code></pre>
  
  <p>and whenever I try to give a path, I'd get an error, probably because of user rights:</p>
  
  <pre><code>spool /tmp/test.lst
  select 1 from dual;
  spool off
  
  
  Cannot create SPOOL file /tmp/test.lst 
  1                      
  ---------------------- 
  1             
  </code></pre>
  
  <p>So my question is where is test.lst?</p>