Re: UTL_FILE directories

nicola_at_my-deja.com wrote:
>
> Hi, everybody.
>
> How can I check the accessible directory list for specifying the path
> for UTL_FILE functions such such as FOPEN ??
>
> I looked in init.ora but haven't seen anything of that kind.
>
> The second question is: how can I modify the accessible directories
> list adn it would be possible to define an accessible directory on a
> client ?
>
> thank you of your help,
>
> Nicola
>
> Sent via Deja.com
> http://www.deja.com/

Look in v$parameter or v$parameter2 where name = 'utl_file_dir'

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"