HI

Have some problem with spooling out some relatively large number of records (~2-3 mil)
Small table - OK though.

Getting error: SP2 0308: cannot close spool file.

Any thoughts?

sqlplus -s user/pwd << EOF 
  set term off
  set head off
  set trims on
  set pages 0
  set feedback off
  set linesize 1000
 
 
      spool test.dat
            select * from small_table; -- OK
            --select * from large_table;  --ERROR
      spool off
  exit 0;
EOF