Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Re : UTL_FILE
On 30 Nov 2002 13:30:40 -0800, yong321_at_yahoo.com (Yong Huang) wrote:
>damorgan <damorgan_at_exesolutions.com> wrote in message news:<3DE7B40E.BF2D2E82_at_exesolutions.com>...
>> No. You need to specify each directory individually.
>>
>> utl_file_dir = C:\dev\client
>> utl_file_dir = C:\dev\client\sub1
>> utl_file_dir = C:\dev\client\sub2
>>
>> Just stack up the utl_file_dir statements one after the other.
>
>That's what the documentation says. But if you put them on one line
>like this: utl_file_dir = c:\temp,d:\temp, it still works.
>
>Yong Huang
As applies to any init.ora parameter with multiple values. Either have them on one line separated with comma's or on individual *adjacent* lines, with *no other parameters interspersed*
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Sat Nov 30 2002 - 17:03:46 CST