Toms pro*c unloader, once you get it running, is simply the fastest way to extract data to a flat file. There is nothing faster. Its very fast. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Greg Rahn Sent: Tuesday, July 14, 2009 11:06 AM To: genegurevich@xxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: parallel select This may be of interest: http://asktom.oracle.com/tkyte/flat/index.html -- Regards, Greg Rahn http://structureddata.org -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l