| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Download data from oracle tables to flat file
Hi Balasubramanian,
> 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.
Try Perl DBI.
=> http://www.symbolstone.org/technology/perl/DBI/index.html
=> http://forteviot.symbolstone.org/cgi/dbi/moduledump?module=DBD::Oracle
Does the trick for me.
Alternatively, you could write a Pro*C-OCI C program for really super-fast access, or a PL/SQL compiled routine, easier to program, probably a bit slower than OCI?
HTH! :-)
rgds,
ad.
 |
 |