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.
Received on Tue May 01 2007 - 07:03:08 CDT
