Question: can we create pfile from spfile?
Answer: A PFILE is necessary in order to create a SPFILE to enable persistent initialization parameters. If you already have a SPFILE, a PFILE can be generated from it using one of the following. CREATE PFILE FROM SPFILE; CREATE PFILE FROM SPFILE = 'production. ora'; CREATE PFILE = '$ORACLE_HOME/dbs/my_pfile.