Re: Oracle-->SQL Server Data transfer

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: dgoulet@xxxxxxxx
  • Date: Thu, 30 Sep 2004 03:38:38 +0100

Contrary to the last time I checked, sqlplus is able 
to write out via spool redirection slightly faster than perl 
can.

I guess Perl loses out on this test.

Jared



On Wed, 29 Sep 2004 11:12:22 -0700, Jared Still <jkstill@xxxxxxxxx> wrote:
> On Wed, 29 Sep 2004 14:03:33 -0400, Goulet, Dick <dgoulet@xxxxxxxx> wrote:
> > look into UTL_FILE package.
> 
> Ugh.
> 
> Use perl.
> 
> It will be *much* faster than writing to a file through utl_file, and with
> no limitations.
> 
> It is also *very* easy  to write.
> 
> Jared
> 
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> 



-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l

Other related posts: