title: oracle sql plus spool
body: <p>I'm using sql plus to execute a query (a select) and dump the result into a file, using spool option.
  I have about 14 millions lines, and it takes about 12 minutes to do the dump.
  I was wondering if there is something to make the dump faster?</p>
  
  <p>Here below my sql plus options:</p>
  
  <pre><code>whenever sqlerror exit sql.sqlcode
          set pagesize 0
          set linesize 410
          SET trimspool ON
          set heading on
          set feedback off
          set echo off
          set termout off
          spool file_to_dump_into.txt 
          select * from mytable;
  </code></pre>
  
  <p>Thanks.</p>