CREATE PFILE SPFILE FROM MEMORY (Oracle 11g)

Oracle 10g :

PFILE



SPFILE



--------------------------------------------------------------------------------

Oracle 11g :

PFILE



SPFILE





MEMORY : Specify MEMORY to create a pfile using the current system-wide parameter settings. In an Oracle RAC environment, the created file will contain the parameter settings from each instance.

---

SQL> create pfile ='/home/oracle/initORA11G.ora' from memory;

File created.

SQL> create spfile = '/home/oracle/spfileORA11G.ora' from memory;

File created.

---

Oracle 10g : PFILE, SPFILE

Oracle 11g : PFILE, SPFILE