|
From: Aaron, N. <na...@gl...> - 2007-04-18 01:23:14
|
You can do a simple bash script that loops through each record returned = by sqlplus and echos it to a text file. Speed will greatly depend an = the number and type of columns you have. If you are familiar with bash = and would like an example let me know and I will email it. Nathan -----Original Message----- From: squ...@li... on behalf of = Jeremy Winston Sent: Mon 4/16/2007 3:42 PM To: squ...@li... Subject: Re: [Squirrel-sql-users] Export Oracle table to Flat file =20 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.=20 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: >=20 > I am new Squirrel User. How can I export an Oracle table (1 Million=20 > records) to a flat file? I am having problems with the size limit. = When I=20 > try to bring up all the table it can't handle. I could always break = the=20 > table in pieces but I am wondering if there is an easier way. I > appreciate=20 > any suggestions. > CB >=20 > _________________________________________________________________ >=20 >=20 --=20 View this message in context: = http://www.nabble.com/Export-Oracle-table-to-Flat-file-tf3543462.html#a10= 022668 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/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
