On May 1, 6:06 pm, Mladen Gogala <mgogala.SPAM..._at_not-at-verizon.net>
wrote:
> 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
mladen, thanks.
I had put together a similar script, but yours is better :)
DBI bugs bit me in the past, and haven't revisited in about 2 yrs.
Will give your script a shot and report back.
Received on Tue May 01 2007 - 19:52:37 CDT
