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 pfile 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 Oracle Commands:
Server Parameters for Oracle
CREATE SPFILE
STARTUP pfile="… "
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