The following perl script will dump entire table to a
flat file, much faster than sqlplus spool.
Please test it in your case and let me know your
result.
Thanks
Charlie cs
#!/usr/bin/perl
use strict;
use DBI;
use DBD::Oracle qw(:ora_types);
my $instance = ('dev');
my $username = ('test');
On Wed, 2004-08-11 at 09:34, Xinyu Wen wrote:
> Hi,
>
> I would like to know if there is a better way to fetch an entire table
> to a file (the file has to be tab delimited) instead of using
> fetchrow_array function? Fetchrow_array is working fine but slow to
> work with a big table.
>
> Thanks
See comments inline:
On Tue, 2004-08-10 at 12:53, [EMAIL PROTECTED] wrote:
> Hiya,
>
> I just finished installing oracle 9.2i on Redhat 9 (Complete client software group)
> and now I am trying to install DBD:Oracle. It isnt going to well.
>
> My Environment variables are all set.. Oracle_home,
On Sat, 2004-08-07 at 15:32, Tim Bunce wrote:
> A mature, and hopefully final, release candidate of DBD::Oracle 1.16
> is available for testing at:
>
> http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc6-20040807.tar.gz
>
RH 8.0
Oracle 10.1
DBI 1.42
I found that 1.16 could not determine
