Re: Fastest way to ASCII file or other ideas?

From: Mladen Gogala <mgogala.SPAM-ME_at_not-at-verizon.net>
Date: Wed, 2 May 2007 00:06:40 +0200 (CEST)
Message-ID: <pan.2007.05.01.22.02.32@not-at-verizon.net>

On Mon, 30 Apr 2007 13:07:51 -0700, EscVector wrote:

> I'm looking for suggestions on the fastest way to dump 100+ Million rows
> from Oracle to an ASCII file.
> We've looked at external table with data pump. This works with speed,
> but that format is proprietary. We've also looked at UTL_FILE and this
> is slow. Looking for ideas suggestions. Streams possibly? Any third
> party freeware?

There is a perl script called dump2csv on my website. It's rather fast if you use the latest DBD::Oracle. It requires Text::CSV module.

-- 
http://www.mladen-gogala.com

Received on Tue May 01 2007 - 17:06:40 CDT