Name

CREATE SPFILE

Synopsis

CREATE SPFILE [= 'spfile_name'] FROM PFILE [= 'pfile_name']

Creates a binary server parameter file by importing the contents of a text initialization parameter file (INIT.ORA or SPFILE). New with Oracle9i Release 2.

Keywords

'spfile_name'

Name of the binary server parameter file that will be created. If spfile_name is not specified, Oracle uses a platform-specific filename, usually INITsid.ORA.

'pfile_name'

Name of the existing text initialization parameter file. If pfile_name is not specified, Oracle uses a platform-specific filename.

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.