Re: modify the location of control files

From: Harald Maier <maierh_at_myself.com>
Date: Thu, 12 Jun 2003 07:52:52 +0200
Message-ID: <m3el1z3kqz.fsf@ate.maierh>

Brian Peasland <oracle_dba_at_remove_spam.peasland.com> writes:

> I haven't tried it myself, but it appears to me that the procedure
> would be as follows:
>
> 1. Issue ALTER SYSTEM SET
> control_files=/newdir/control01.ctl,.....,/newdir/control03.ctl
> SCOPE=SPFILE;
> This changes the parameter in the SPFILE, but not for the active
> instance.

This produces the following error:

02095, 00000, "specified initialization parameter cannot be modified" // *Cause: The specified initialization parameter is not modifiable Received on Thu Jun 12 2003 - 00:52:52 CDT