Oracle Create spfile from memory

 

Oracle Create spfile from memory





create spfile from memory;
create spfile from memory
*
ERROR at line 1:
ORA-32002: cannot create SPFILE already being used by the instance  


Use below command 

spfile 
create spfile='/home/oracle/spfileanuj.ora' from memory;

File created.


pfile 
create pfile='/home/oracle/pfileanuj.ora' from memory;
File created.