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 -> Fastest way to ASCII file or other ideas?

Fastest way to ASCII file or other ideas?

From: EscVector <Junk_at_webthere.com>
Date: 30 Apr 2007 13:07:51 -0700
Message-ID: <1177963670.949104.145390@y80g2000hsf.googlegroups.com> 





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?
Received on Mon Apr 30 2007 - 15:07:51 CDT












Original text of this message













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