Re: How change Spfile parameter?

Sorry.....

I understan that Spfile don't be send by parameter in startup

please checkme I am novice in this....

Brian Peasland ha escrito:

> > alter system set
> > spfile='D:\Software\Oracle_Express\PFILES\MIENTRAS_XE_SPFILE'
> > *
> > ERROR at line 1:
> > ORA-02095: specified initialization parameter cannot be modified
>
> This parameter is set when you start the instance. If you want to start
> the instance with a different SPFILE, then use the following:
>
> STARTUP SPFILE='/directory/spfile'
>
> When the instance has been started, query V$PARAMETER again to see the
> change.
>
> If you do not specify the SPFILE on startup, then the default is used.
>
>
> HTH,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
Received on Fri Sep 22 2006 - 15:05:09 CDT