Re: Fastest way to ASCII file or other ideas?

From: John <john_miller_portland_at_hotmail.com>
Date: 7 May 2007 17:03:04 -0700
Message-ID: <1178582584.023950.48950@l77g2000hsb.googlegroups.com>

I have a doubt you can find a "freeware" or "shareware" that will be also the "fastest".
Pro*C will be the fastest "free" way.

I find fastreader as a very fast tool to extract data from Oracle into ASCII format. Fastreader ( http://www.wisdomforce.com) probably is the most popular among commercial tools for purpose of dumping Oracle tables into text.

On Apr 30, 1:07 pm, EscVector <J..._at_webthere.com> wrote:
> I'm looking for suggestions on the fastest way to dump 100+ Million
> rows fromOracleto 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 isslow. Looking for ideas suggestions. Streams possibly? Any
> third party freeware?
Received on Mon May 07 2007 - 19:03:04 CDT