*** EXPORTING DATA

Here is how to export data to a space delimited text file

SET LINESIZE 500 FEEDBACK OFF TRIMSPOOL ON TERMOUT OFF HEAD OFF PAGESIZE 0 term off
SPOOL /directory/name/outputfile.dat
SELECT * from table;
SPOOL OFF