Re: Write millions of records of data to a flat file

I seem to get stuff fast enough with a simple sqlplus -s << EOF > trans1$$.dat
$schema/$password
set colsep |
set verify off
set echo off
set feedback off
set pages 0
set heading off
set termout off
set linesize 100
select
...

from ...
where ... and
...

;
EOF Your colsep and linesize may vary. Also, you can echo the commands into sqlplus and then on to whatever unix utilities you need to transform and clean.

There's probably some I forgot, so show all in sqlplus.

jg

--
@home.com is bogus.
Billionaire next door:
http://www.forbes.com/forbes/1999/1011/6409050a.html