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: Bjørn Dörr Jensen <B.D.Jensen_at_gmx.net>
Date: Wed, 22 Feb 2006 19:37:00 +0100
Message-ID: <000d01c637de$f7da63f0$6801a8c0@camelopardalis>


Hi!
yes, an good solution for reading files, but what about writing files - are there better solutions than utl_file?
/Greetings Bjoern

>> 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
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 22 2006 - 12:37:00 CST

Original text of this message

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