Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle-->SQL Server Data transfer

Re: Oracle-->SQL Server Data transfer

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 30 Sep 2004 03:38:38 +0100
Message-ID: <bf463804092919386aeb47e8@mail.gmail.com>


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_at_gmail.com> wrote:
> On Wed, 29 Sep 2004 14:03:33 -0400, Goulet, Dick <dgoulet_at_vicr.com> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 29 2004 - 21:34:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US