Re: Problem with some simple PL/SQL.

On 2005-07-24, Paul <paul_at_see.my.sig.com> wrote:
>
>
>
> Rene Nyffenegger <rene.nyffenegger_at_gmx.ch> wrote:
>
>>The exact text and/or number of error messages is useful (!= "it didn't work!").
>
>
> SP2-0735: unknown SET option beginning "utl_file_d..."
>
>
> Hoist by my own petard!!! 8-)
>
>
>>Try:
>>alter system set utl_file_dir='c:\temp' scope = spfile;
>>Then restart the database.
>
>
> This worked! Merci + Danke!
>
>
> God, this damn Oracle thing is so complex that sometimes I feel as if
> I'll never get the hang of it!
>
>
> One thing is confusing me though, the in file init.ora.55200519471
> which is in D:\oracle\admin\MyDB\pfile was, I thought, the one for the
> db, but it's mod date and time are still from a few hours ago. Where
> is the file that has obviously been modified?

You can check whether an spfile is used with show parameter spfile.

If value is not null, it's the location for the spfile.

If it is null, it will either use the default init.ora file (init$ORACLE_SID.ora) or the one given by starting up the database (pfile=...)

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/