Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Faster option than utl_file

RE: Faster option than utl_file

From: Michael Fontana <MFontana_at_verio.net>
Date: Wed, 22 Feb 2006 11:57:41 -0500
Message-ID: <87E07E8CF4B26D4587451BE788F5C3217FC891@IAD-WPRD-XCHB02.corp.verio.net> 





>  Is there a faster alternative? Or any way to tune utl_file?

> 

> Platform is Oracle 9i on AIX 5.




Oracle's good old sql*loader has a bulk load feature, and there is a new
PL/SQL bulk load syntax that is supposed to held with the IO.  Read the
latest PL/SQL book by Fuerstein for some excellent suggestions:


 


http://www.overstock.com/cgi-bin/d2.cgi?cid=52445&PAGE=PRODUCT&PROD_ID=1
82454&fp=F&kid=711057


--
http://www.freelists.org/webpage/oracle-l


Received on Wed Feb 22 2006 - 10:57:41 CST












Original text of this message













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