I want to switch from init.ora to spfile, can some one tell me how to do this.
Issue the create spfile from pfile command.
This question / answer was posted here to get paid, but not done as promised, so this question / answer should be deleted from the site.