First page Back Continue Last page Graphics

…CREATE SPFILE…


Notes:

The CREATE SPFILE command in its simplest form does not require file names or paths. In this example, Oracle uses the operating system specific defaults for file locations and uses a default naming scheme of spfile$ORACLE_SID.ora. The default location on Windows 2000 is the ORACLE_HOME\database folder.

Your Oracle username must have been granted either the SYSDBA or SYSOPER system privilege in order for you to be able to execute the CREATE SPFILE command.