Re: Export Oracle table to Flat file

Squirrel is too slow for retrieving massive data amounts. sqlplus will be
slow too
You may want to write some Pro*C scripts to extract data from Oracle into
flat file. 
Or if to get really high-end performance for export into flat files (
200,000 - 300,000 rows per second ) then look into commercial tools.  For
instance Fastreader (http://www.wisdomforce.com) is good way to go


Carolina Barcenas wrote:
> 
> I am new Squirrel User.  How can I export an Oracle table (1 Million 
> records) to a flat file?  I am having problems with the size limit. When I 
> try to bring up all the table it can't handle. I could always break the 
> table in pieces but I am wondering if there is an easier way.  I
> appreciate 
> any suggestions.
> CB
> 
> _________________________________________________________________
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Export-Oracle-table-to-Flat-file-tf3543462.html#a10022668
Sent from the squirrel-sql-users mailing list archive at Nabble.com.


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/