First page Back Continue Last page Graphics
…CREATE SPFILE
CREATE SPFILE can be executed:
- Instance stopped
- Existing SPFILE overwritten if exists
- No warning given!
- “OR REPLACE” option not supported
- Instance started
- Error occurs if SPFILE exists
- ORA-32002: cannot create SPFILE already being used by the instance
Notes:
The CREATE SPFILE command can be run before or after instance startup. If the CREATE SPFILE is executed while your instance is down and a SPFILE already exists in the location specified in the command and has the same file name as the command requests, then the existing SPFILE will be OVERWRITTEN. If an instance is already running using a SPFILE and a CREATE SPFILE command is executed and attempts to overwrite the existing SPFILE, then an error will occur.
If an instance is already running using an SPFILE and a CREATE SPFILE command is executed and attempts to overwrite the existing SPFILE, then an error will occur.