Re: Changing the spfile on 9.2.0.3

If you already have an spfile you cant create another one.

You can delete the old one of you wish and re-create it like that.

If you didnt know you can change any parameters with alter system set <parameter> = <value> scope = spfile;

Dont have to keep creating a new one

On Thu, 11 Nov 2004 11:40:55 +0200, Denham Eva <evad_at_tfmc.co.za> wrote:
> Hello Folks
>
> I am trying to "update"/"change" the spfile with the edited init.ora
> file under pfile in admin.
>
> I start the database startup mount;
>
> Then use the
>
> CREATE SPFILE FROM PFILE='PATH\TO\INIT\PFILE\INIT.ORA';
>
> But Oracle complains that the spfile is already in use.
>
> Must I use a different name ie change the name of spfile? OR can I
> update/alter spfile?
>
> OR is there something with the method?
>
> TIA
>
> Denham
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l