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: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Wed, 22 Feb 2006 11:40:56 -0700
Message-ID: <7209E76DACFED9469D4F5169F9880C7A9C04@mail01bldr.arraybp.com>


Sure. Use SQL*Plus and spool to a file. Run this from oracle's crontab instead of dbms_jobs, or use extproc Perl and use Perl called from a stored procedure from within the database.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bjrn Drr Jensen
Sent: Wednesday, February 22, 2006 11:37 AM
To: MFontana_at_verio.net; oracle-l_at_freelists.org
Subject: Re: Faster option than utl_file


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

----- Original Message ----- 
From: "Michael Fontana" <MFontana_at_verio.net>
To: <oracle-l_at_freelists.org>
Sent: Wednesday, February 22, 2006 5:57 PM
Subject: RE: Faster option than utl_file



>> 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 This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system. -- http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 22 2006 - 12:40:56 CST

Original text of this message

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