Re: Fastest way to ASCII file or other ideas?

On May 3, 11:38 am, DA Morgan <damor..._at_psoug.org> wrote:
> EscVector wrote:
> > On May 2, 4:11 pm, joel garry <joel-ga..._at_home.com> wrote:
> >> 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."
>
> > I didn't want the simplest way to dump rows I wanted the fastest
> > way.
> > Asking for brainstorm, suggestions, ideas, sanity check.
>
> > I think simple would be running from sqlplus. That was mentioned.
> > I'm biased toward perl or C. These were also suggested.
>
> You haven't really stated why you want to dump the data? If you
> did so it might open insights into other options.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Transfer to 3rd party app the requires ASCII file input. No way around it.
Must have a ASCII flat or delimited file. No API into the system. Crazy eh?

So it is in Oracle and we need it in the other system, the system only takes flat files input.

I had thought about creating a pipe/stream that feeds the system, thus no real flat file, but audit issues prevented that. Received on Thu May 03 2007 - 11:32:37 CDT