How change Spfile parameter?

From: Mr.EthanHunt <MrEthanHunt_at_gmail.com>
Date: 22 Sep 2006 07:53:20 -0700
Message-ID: <1158936800.203281.40330@b28g2000cwb.googlegroups.com>

Hi Group.....

      I am new in oracle and need change the spfile parameter value on v$parameter view, I Looked information and found the following:

     The change must be done with "Alter system".

    I execute:

SQL> alter system set
spfile='D:\Software\Oracle_Express\PFILES\MIENTRAS_XE_SPFILE';

nevertheless it gives back :

alter system set
spfile='D:\Software\Oracle_Express\PFILES\MIENTRAS_XE_SPFILE'

                 *

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

¿How change the famous parameter ?

Thanks in advance..... Received on Fri Sep 22 2006 - 09:53:20 CDT