Re: Problem with some simple PL/SQL.

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Mon, 25 Jul 2005 17:28:13 +0000 (UTC)
Message-ID: <dc37fd$9cg$2@klatschtante.init7.net>

On 2005-07-25, Paul <paul_at_see.my.sig.com> wrote:
>
>
>
> 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?
>
>
> I got this info here
> http://www.adp-gmbh.ch/ora/sql/alter_system.html
>
>
> 8-)

Hm, let's see

SQL> alter system set utl_file_dir='c:\temp' scope = both; alter system set utl_file_dir='c:\temp' scope = both

                 *

ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

Well, this page, as many others, should maybe be cleaned up a bit...

>
>
> 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';?

look into

select isses_modifiable, issys_modifiable, name from v$parameter;

hth,
Rene

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

Received on Mon Jul 25 2005 - 12:28:13 CDT