Re: Problem with some simple PL/SQL.

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Mon, 25 Jul 2005 19:23:13 +0200
Message-ID: <42e5210a$0$18010$9b4e6d93@newsread4.arcor-online.net>

Paul schrieb:
>
>
> 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?
>

Yes, you could simply try it...
>
> 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';?
>
>

You don't issue SQL statement against v$parameter, you change your initialization parameter, you can do it for scope MEMORY (change valid until restart of instance ), SPFILE ( change valid after restart of instance ) and BOTH ( change valid until and after restart as well)

To see whether you can modify a paraameter for scope MEMORY , you should query:

SELECT issys_modifiable
FROM v$parameter
WHERE NAME = 'your desired parameter'

If you issue this query for 'utl_file_dir', you would get FALSE, that means , it is not modifiable (for scope MEMORY) . You can also make the change only by writing into spfile (resp. init.ora) and restarting instance.

> I've tried googling, but can't seem to find it.
>
>
>

>>Rene

>
>

Here you can read in detail about this:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2012.htm#sthref3536

Best regards

Maxim Received on Mon Jul 25 2005 - 12:23:13 CDT