Re: UTL Directory Location

Re: UTL Directory Location

 

  

Got check the init.ora file..that is where it is
set....

HTH,

Kelly

--- Peace On Earth <[Email Address Removed] wrote:
> How do I find which directory UTL writes into
>
> I have queried V$parameter
>
> SQL> select * from v$parameter where name like
> '%utl%';
>
> NUM NAME
>
> TYPE
> ----------
>
----------------------------------------------------------------
> ----------
> VALUE
>
--------------------------------------------------------------------------------------
> ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ
> DESCRIPTION
> --------- ----- --------- ---------- -----
> -------------------------------------------
> 424 utl_file_dir
>
> 2
>
> TRUE FALSE FALSE FALSE FALSE utl_file
> accessible directories list
>
>
>
> In which table or view can I find the directory
> location and where can this be changed?
>
> Rizwan
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> http://mailplus.yahoo.com
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


=====
....Yeah...my other account is down...so, using this again.......

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
Oracle LazyDBA home page