CREATE SPFILE

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

Syntax:

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

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

You can execute this statement either before or after instance startup. If you have already started the instance using spfile_name, you cannot specify the same spfile_name in this statement.

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

"There are 10 kinds of people in the world:
those who understand binary, and those who don’t"

Related Oracle Commands:

Server Parameters for Oracle
CREATE PFILE
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