Re: Fastest way to ASCII file or other ideas?

On Apr 30, 10:35 pm, hpuxrac <johnbhur..._at_sbcglobal.net> 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?
>
> Traditionally for best speed one tactic is a c program running on same
> server as database use bequeath or ipc type connection.

Hi,
I have implemented a Pro*C download program at our shop from a sample by Tom Kyte. See http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:459020243348. It is an excellent little prototype, with which you can reach incredible output speeds!
You may need to know a little Pro*C though.

Regards,
Erik Ykema Received on Tue May 01 2007 - 04:29:54 CDT