24 February 2006

Re: How to rename SPFILE to PFILE and vice versa.

Learn something new yesterday on how to edit the parameter file (initsid.ora) in Oracle. If is already in spsid.ora format, do a 'create pfile from spfile', and manually edit the init file, after that to a 'create spfile from pfile'. Check this out at

http://www.oracle-base.com/articles/9i/PersistentInitializationParameters.php