Re: Fastest way to ASCII file or other ideas?

On May 2, 6:52 am, EscVector <J..._at_webthere.com> wrote:
> On Apr 30, 4:07 pm, EscVector <J..._at_webthere.com> 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?
>
> Thanks for the replies:
> We tested with sqlplus option, but the lack or real programmatic
> within sqlplus makes this a last resort option.

What exactly do you need to do? This started off as simply dumping rows to ASCII.

>
> Performance Based Options Synopsis:
> 1. Use ProC
> 2. Use Perl
>
> No need to re-invent the wheel, use existing code samples and come up
> with something that works fast.
>
> Thanks!

jg

--
@home.com is bogus.
If an optimist looks a glass of water and says "it's half full", and a
pessimist looks and says "its half empty"... The DBA will look and say
"that glass looks twice as big as it needs to be - is the water
increasing or decreasing?  Better get another glass to back it up."