You don't "edit" spfile. Modify it using: Alter system set <parameter>=<value> scope=spfile #or scope=both -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dean Paul Sent: Wednesday, April 26, 2006 2:00 PM To: oracle-l@xxxxxxxxxxxxx Subject: How to edit spfile ?/ Without creating pfile from spfile how can we edit spfile ? thx _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l