Re: UTL_FILE ORA-29280: invalid directory path

From: Jake <jgarfield_at_earthlink.net>
Date: Sun, 04 Nov 2007 11:18:20 -0800
Message-ID: <1194203900.755182.141150@57g2000hsv.googlegroups.com>

On Nov 4, 1:09 pm, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> Jake <jgarfi..._at_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.

thanks.

ALTER SYSTEM SET UTL_FILE_DIR='D:\oracle_files' scope=spfile

and restarting makes everything work. Received on Sun Nov 04 2007 - 13:18:20 CST