top of page

Oracle:

CREATE SPFILE

CREATE SPFILE [= 'spfile_name' ]
FROM { PFILE [= 'pfile_name' ]
| MEMORY
} ;

Example

CREATE SPFILE
FROM PFILE = '$ORACLE_HOME/work/t_init1.ora';

CREATE SPFILE = 's_params.ora'
FROM PFILE = '$ORACLE_HOME/work/t_init1.ora';

STARTUP PFILE=new_param.ora

bottom of page