Re: Export Oracle table to Flat file

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: squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx on behalf of Jeremy Winston
Sent: Mon 4/16/2007 3:42 PM
To: squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Squirrel-sql-users] 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/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

-------------------------------------------------------------------------
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
Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users