Топ-100
 
CerebroSQL

CREATE SPFILE

RDBMS Type: Oracle

unnamed (2).png

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