I have to extract several large tables to pipe delimited text files. In total, the tables are about

My sql script has the following sytnax:

set colsep '|';

set echo       off;

set feedback   off;

set heading    off;

set linesize   32767;

set pagesize   0;

set termout    off;

set trimspool  on;

set verify     off;

set timing on;

spool tbl1_flatfile.txt

select * from tbl1;

spool off;