CREATE PFILE

Export a binary server parameter file into a text initialization parameter file (INIT.ORA).

Syntax:

   CREATE PFILE [='pfile_name'] FROM SPFILE [='Spfile_name'];

A text parameter file can be easily edited in a text editor.

You can execute this statement either before or after instance startup.

Oracle will look for default files, but typically you will need to specify the full pathname.

"Creation proceeds from moment to moment" - N. M. Chatterjee

Related Commands:

CREATE SPFILE
CREATE USER
ALTER USER

Related Views:

 USER_PASSWORD_LIMITS
 SESSION_ROLES
 SESSION_PRIVS
 SESSION_CONTEXT
 DBA_TS_QUOTAS                          USER_TS_QUOTAS
 DBA_USERS             ALL_USERS        USER_USERS
 V$SESSION
 V$SESSION_CONNECT_INFO