Re: UTL_FILE ORA-29280: invalid directory path

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 04 Nov 2007 18:09:30 GMT
Message-ID: <uVnXi.1452$L15.463@newsfe08.phx>

Jake <jgarfield_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. Received on Sun Nov 04 2007 - 12:09:30 CST