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 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:

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


© Copyright SS64.com 1999-2013
Some rights reserved