Try this...
SQL> set pages 0
SQL> set heading off
SQL> set feedback off
SQL> spool yourfilename.txt
SQL> select * from your_table_here;
SQL> spool off
SQL> set feedback on
SQL> set heading on



CriticalJ@gmail.com wrote:
> I have been asked to export some oracle tables to text files. The main
> problem I am having is the resulting file.
>
> The sql for the requested fields is stuck at the top of the file and
> spool off is at the bottom.
>
> I have used Set ECHO OFF at the top of the command as well as several
> other set commands but nothing seems to stop this.
>
> The solution is probably easy but I am not a regular Oracle user so it
> is eluding me. If anyone could direct me to a solution, I would
> appreciate it greatly.
>
> Thank you.