First page Back Continue Last page Graphics
…CREATE SPFILE…
Must have SYSDBA or SYSOPER system privileges
Database Configuration Assistant support too
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.