Re: Problem with some simple PL/SQL.

"Paul" <paul_at_see.my.sig.com> wrote in message news:qm6ae1to9u8jtrdnvqrvh350vr644quhu6_at_4ax.com...
>
>
>
> Rene Nyffenegger <rene.nyffenegger_at_gmx.ch> wrote:
>
>>Try:
>>alter system set utl_file_dir='c:\temp' scope = spfile;
>>Then restart the database.
>
>
> could I not simply have done
>
> alter system set utl_file_dir='c:\temp' scope = both?

nope, scope = both implies an in memory change and utl_file requires a restart, so it simply wont let you do that

>
>
> I got this info here
> http://www.adp-gmbh.ch/ora/sql/alter_system.html
>
>
> 8-)
>
>
>
> Paul...
>
>
> BTW, how can I know/find out which parameters are changeable by
> altering the system and restarting, and which ones can be changed
> dynamically, on the fly, by issuing an SQL statement against
> v$parameters, or by issuing a command from SQLPlus set
> paramname='Blah';?
>
>

there is a column in v$parameter or v$spparameter which is determines - ill look it up later Received on Mon Jul 25 2005 - 12:18:46 CDT