RE: Oracle-->SQL Server Data transfer

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@xxxxxxxxx]
Sent: Wednesday, September 29, 2004 10:39 PM
To: Goulet, Dick
Cc: harvinder.singh@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> =
wrote:
> On Wed, 29 Sep 2004 14:03:33 -0400, Goulet, Dick <dgoulet@xxxxxxxx> =
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

Other related posts: