Oracle Database Design - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 197

have these products added to your database. Consult the Oracle
documentation for procedure and installation.
Manual Database Design: Step 10
Create Server Parameter File (Highly Recommended)
It is highly recommended to have a server parameter file created
or in other words SPFILE from PFILE. SPFILE give you the
ability to make dynamic changes to the initialization parameters
using ALTER SYSTEM statement without the need to restart the
Oracle Database. The statement to create the SPFILE given
below.
C:\>sqlplus /nolog
SQL>CONNECT SYS/password AS SYSDBA
SQL>CREATE SPFILE FROM PFILE;
SQL>SHUTDOWN
C:\>sqlplus /nolog
SQL>CONNECT SYS/password AS SYSDBA
SQL>STARTUP
SQL>EXIT
Manual Database Design: Step 11
Create Additional Users, Grant Them Quotas On
Tablespaces, Privileges/Roles
This is an optional step. Now you can create new users, grant
them quotas on tablespaces, assign them privileges, profiles or
Roles.