Re: Problem with some simple PL/SQL.

"Paul" <paul_at_see.my.sig.com> wrote in message news:but7e1l3bar3sflerqk4aa1di8kknjaqpg_at_4ax.com...
>
>
>
> 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?
>
>

dbca uses the file init.ora to create the database, once it is done it creates an spfile and renames the init.ora file (appends a timestamp to it) so that you dont use it.

If someone edits that file, then they arent changing anything Received on Sun Jul 24 2005 - 15:31:39 CDT