I think there is 1 line in spfile ,after changing that line we can edit
spfile directly I think but I don't know .
alter system and pfile are common way to edit.
From: "Alex Gorbachev" <gorbyx@xxxxxxxxx> To: oracledbam@xxxxxxxxxxx CC: oracle-l@xxxxxxxxxxxxx Subject: Re: How to edit spfile ?/ Date: Wed, 26 Apr 2006 20:19:34 +0200
AFAIK, only if you database is started with this spfile. Than use ALTER SYSTEM SET ... SCOPE=SPFILE;
2006/4/26, Dean Paul <oracledbam@xxxxxxxxxxx>: > Without creating pfile from spfile how can we edit spfile ? > thx
-- Best regards, Alex Gorbachev