Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Fastest way to ASCII file or other ideas?

Re: Fastest way to ASCII file or other ideas?

From: spin <ivancrocce_at_gmail.com>
Date: 1 May 2007 07:29:04 -0700
Message-ID: <1178029744.068316.25320@q75g2000hsh.googlegroups.com>


On May 1, 9:03 am, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On May 1, 5:29 am, ErikYkema <erik.yk..._at_gmail.com> wrote:
>
>
>
> > 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. Seehttp://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4....
> > 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
>
> Yeah thanks I have seen that discussion item before ... everyone in
> the dba area "should be able" to hack together a little Pro C when
> required. Of course oracle supplies sample programs and instructions
> etc which along with the sample program from Tom Kyte's forum gives a
> good starting point.

Perhaps the OWB can be used. Received on Tue May 01 2007 - 09:29:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US