Re: Fastest way to ASCII file or other ideas?
- From: EscVector <Junk@xxxxxxxxxxxx>
- Date: 30 Apr 2007 13:51:07 -0700
On Apr 30, 4:35 pm, hpuxrac <johnbhur...@xxxxxxxxxxxxx> wrote:
On Apr 30, 4:07 pm, EscVector <J...@xxxxxxxxxxxx> 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.
Great suggestion. Thought of this but they didn't want to go with C
or C++. Will explore concurrency/threading issues and maybe I can
convince that it's not so bad.... I've only ever created single
threaded C processes. What to do if C/native can't be used?
.
- Follow-Ups:
- Re: Fastest way to ASCII file or other ideas?
- From: joel garry
- Re: Fastest way to ASCII file or other ideas?
- From: hpuxrac
- Re: Fastest way to ASCII file or other ideas?
- References:
- Fastest way to ASCII file or other ideas?
- From: EscVector
- Re: Fastest way to ASCII file or other ideas?
- From: hpuxrac
- Fastest way to ASCII file or other ideas?
- Prev by Date: Re: how to find if instance started by pfile or spfile
- Next by Date: Re: Log apply services with RMAN
- Previous by thread: Re: Fastest way to ASCII file or other ideas?
- Next by thread: Re: Fastest way to ASCII file or other ideas?
- Index(es):
Relevant Pages
|
