RE: Oracle-->SQL Server Data transfer
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: "Jared Still" <jkstill@xxxxxxxxx>
- Date: Thu, 30 Sep 2004 09:22:58 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
