Fastest way to ASCII file or other ideas?

From: EscVector <Junk@xxxxxxxxxxxx>
Date: 30 Apr 2007 13:07:51 -0700

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?

.

Follow-Ups:
- Re: Fastest way to ASCII file or other ideas?
  - From: hpuxrac

Prev by Date: Help, please. Unneeded variable replacement verbiage spooled to output file.
Next by Date: Log apply services with RMAN
Previous by thread: Help, please. Unneeded variable replacement verbiage spooled to output file.
Next by thread: Re: Fastest way to ASCII file or other ideas?
Index(es):
- Date
- Thread

Relevant Pages

Re: Fastest way to ASCII file or other ideas?
... rows from Oracle to an ASCII file. ... We've looked at external table with data pump. ... but that format is proprietary. ...
(comp.databases.oracle.server)
Re: Fastest way to ASCII file or other ideas?
... We've looked at external table with data pump. ... Puget Sound Oracle Users Groupwww.psoug.org ... Transfer to 3rd party app the requires ASCII file input. ... takes flat files input. ...
(comp.databases.oracle.server)
Re: Fastest way to ASCII file or other ideas?
... rows from Oracle to an ASCII file. ... We've looked at external table with data pump. ... but that format is proprietary. ...
(comp.databases.oracle.server)
Re: Fastest way to ASCII file or other ideas?
... from Oracle to an ASCII file. ... We've looked at external table with data pump. ... but that format is proprietary. ...
(comp.databases.oracle.server)
Re: Fastest way to ASCII file or other ideas?
... rows from Oracle to an ASCII file. ... We tested with sqlplus option, but the lack or real programmatic ... "that glass looks twice as big as it needs to be - is the water ... Puget Sound Oracle Users Group ...
(comp.databases.oracle.server)