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 Bjørn Dörr 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
