RE: Faster option than utl_file

  • From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
  • To: <B.D.Jensen@xxxxxxx>, <MFontana@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 22 Feb 2006 11:40:56 -0700

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Bjørn Dörr Jensen
Sent: Wednesday, February 22, 2006 11:37 AM
To: MFontana@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Faster option than utl_file

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@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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:
> =1
> 82454&fp=F&kid=711057
> --


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
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.


Other related posts: