Following a spot of re-organising on my Linux server, I want my 10g database to use the spfile in /opt/oracle/newdir but I cannot amend v$parameter to tell the database to stop using the spfile in /opt/oracle/olddir. Is there a (painless) way of switching spfiles?
