Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!nx01.iad01.newshosting.com!newshosting.com!69.28.186.77.MISMATCH!hwmpeer03.lga!hwmnpeer01.lga!news.highwinds-media.com!hw-filter.phx!newsfe08.phx.POSTED!53ab2750!not-for-mail
Newsgroups: comp.databases.oracle.server
Subject: Re: UTL_FILE ORA-29280: invalid directory path
From: "Ana C. Dent" <anacedent@hotmail.com>
References: <1194193313.848824.115020@19g2000hsx.googlegroups.com> <1194194161.900494.161960@19g2000hsx.googlegroups.com>
Organization: Your Company
User-Agent: Xnews/5.04.25
Lines: 24
Message-ID: <uVnXi.1452$L15.463@newsfe08.phx>
X-Complaints-To: admin@cox.net
NNTP-Posting-Date: Sun, 04 Nov 2007 11:09:30 MST
Date: Sun, 04 Nov 2007 18:09:30 GMT
Xref: usenetserver.com comp.databases.oracle.server:437260
X-Received-Date: Sun, 04 Nov 2007 13:09:31 EST (text.usenetserver.com)

Jake <jgarfield@earthlink.net> wrote in news:1194194161.900494.161960@
19g2000hsx.googlegroups.com:

> okay so I thought maybe it was that i added single quotes to the line
> in init.ora, so I changed to:
> 
> UTL_FILE_DIR = D:\oracle_files
> 
> then I restarted.  but still:
> 
> SQL> show parameter utl_file_dir;
> 
> NAME                                 TYPE        VALUE
> ------------------------------------ -----------
> ------------------------------
> utl_file_dir                         string
> 
> 
> 
> what am I doing wrong here?
> 

If your datbase uses the spfile to obtain its parameters,
then changing the pfile is an exercise in futility.