> "Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> wrote in message
> news:dc0slg$1ah$1_at_klatschtante.init7.net...
>> On 2005-07-24, Paul <paul_at_see.my.sig.com> wrote:
>>>
>>>
>>> "Dave" <x_at_x.com> wrote:
>>>
>>>
>>>>> utl_file_dir='D:\Paul'
>>>
>>>>when logged into sqlplus
>>>
>>>>do
>>>>show parameter utl_file (make sure it is set in your current session)
>>>
>>>
>>> NAME TYPE VALUE
>>> ----------- ----------- ------------------------------
>>> utl_file_dir string
>>>
>>>
>>>
>>> No value is apparently set.
>>>
>>>
>>> It's definitely in the spfile. Any ideas as to how I can set it? I
>>> tried
>>>
>>> SET utl_file_dir = 'D:\Paul';
>>> SET utl_file_dir = D:\Paul;
>>>
>>>
>>> Neither of which worked.
>>
>> The exact text and/or number of error messages is useful (!= "it didn't
>> work!").
>>
>> Try:
>> alter system set utl_file_dir='c:\temp' scope = spfile;
>> Then restart the database.
>>
>> hth
>> Rene
>>
>
> except replace the directory for that which you want
Of course. I am just too used to setting it to c:\temp ...
--
Rene Nyffenegger
http://www.adp-gmbh.ch/
Received on Sun Jul 24 2005 - 15:29:29 CDT
