Re: How to edit spfile ?/

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: tomday2@xxxxxxxxx
  • Date: Thu, 27 Apr 2006 12:00:45 -0700

Do you have examples of what cannot be modified via

alter system set <parm>=<value> scope = spfile;


On 4/26/06, Thomas Day <tomday2@xxxxxxxxx> wrote:

Usually the parameter that I want to change is something that can't be
changed via ALTER SYSTEM.  Very rarely do I get lucky and edit the spfile
such that the checksum is still valid.  The only way that I know of to
always be able to alter the parameter in spfile is to create a pfile from
the spfile, edit the pfile, restart the database from the pfile and create
an spfile from the pfile.

HUGE pain.  Not a fan of spfile at all.  Only use it when management

-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: