OracleDB‎ > ‎

Init File

Oracle SPFile and PFILE

CREATE spfile FROM pfile;

You can also create a new init.ora file from the SPFILE in the default location by using the following command:

SQL> CREATE pfile FROM spfile; File created. SQL>

or use specify a file

CREATE PFILE = '$ORACLE_HOME/dbs/my_pfile.ora' FROM SPFILE;
Comments