RE: Oracle-->SQL Server Data transfer

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Thu, 30 Sep 2004 09:22:58 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA650146C79E@25exch1.vicorpower.vicr.com>

OH MY GOD!! Someone get out the red paint & mark the wall!! *-)

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Wednesday, September 29, 2004 10:39 PM To: Goulet, Dick
Cc: harvinder.singh_at_metratech.com; oracle-l_at_freelists.org Subject: Re: Oracle-->SQL Server Data transfer

Contrary to the last time I checked, sqlplus is able=20 to write out via spool redirection slightly faster than perl=20 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.

>=20

> Ugh.

>=20

> Use perl.

>=20
> It will be *much* faster than writing to a file through utl_file, and =
with
> no limitations.

>=20

> It is also *very* easy to write.

>=20

> Jared

>=20

> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>=20

--=20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 30 2004 - 08:18:36 CDT