Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance of UTL_FILE package
Niklas
I can't make comparisons with the Pro*XXX family, but I don't have any complaints. It *is* limited to explicitly stated directories in the init.ora (or the ill-advised * allowing all directories; I hope Oracle upgrades this feature to genuine wildcards).
What I find useful is that it allows you to monitor progress in a long query. For example, if I'm loading a 50 000 record file, I can create a count as I loop round and every 500 (say) output the total count so far.
Len
On Mon, 22 Jun 1998 09:47:56 +0200, "Niklas Iveslatt" <niklas_iveslatt_at_mail.amsinc.com> wrote:
>Hi,
>
>I was wondering if anyone has had any experience in using a stored procedure
>to select a massive amount of data and dump it to a file using
>the UTL_FILE package....
>
>I would appreciate any input,
>
>Niklas
>
>
Received on Sun Jun 28 1998 - 00:00:00 CDT