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 -- //www.freelists.org/webpage/oracle-l