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.
Received on Mon Apr 30 2007 - 15:35:45 CDT
