Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: utl_file paths
Yes you just have to make these entries in the initORACLE_SID.ora file:
utl_file_dir = *
After you restart the instance you should be able writing to any Directory on the disk
Regards
Mario Bucsics, SIEMENS AG
Sean Dillon wrote:
> (NT Environment)
> I'd like to use the utl_file package in a trigger to export inserted or
> updated data to a text file. I'm having trouble identifying the path -
> local paths work fine because they can be referred to simply, like '/mydir',
> but I can't seem to figure out how to specify a share. Have tried UNCs and
> permanent drive-letter mappings.
>
> Anybody successfully used utl_file to write to a dir on a machine other than
> the Oracle server itself?
Received on Tue Aug 17 1999 - 13:00:21 CDT