Re: Download data from oracle tables to flat file

At www.teleport.com/~jkstill/util you will find dump.sql.

This is a utility for dumping your table to a quota and comma delimited file.

SQL*Plus is not slow at dumping to a flat file. C may do it faster, but not enough to make it worth writing a program for.

For the small amount you are talking about, it will be very fast.

Jared

On Thu, 4 May 2000, Balasubramanian M wrote:

>
> Hi all,
>
> Is there any way to unload the data to flat file other than using
>
> spool on
> select * from <table_name>
>
> For very large table having thousands of rows, the above technique will be
> very slower.
>
> Is there any other way i can unload the data from the tables faster ?
> Any kinf of help is appreciated.
>
>
> Regards,
>
> Balasubramanian .M
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Fri May 05 2000 - 11:52:20 CDT