Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Changing the spfile on 9.2.0.3
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-lReceived on Thu Nov 11 2004 - 03:35:24 CST