Skip Headers
Oracle® Database SQL Language Reference
11g Release 1 (11.1)

Part Number B28286-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF



Use the CREATE PFILE statement to export either a binary server parameter file or the current in-memory parameter settings into a text initialization parameter file. Creating a text parameter file is a convenient way to get a listing of the current parameter settings being used by the database, and it lets you edit the file easily in a text editor and then convert it back into a server parameter file using the CREATE SPFILE statement.

Upon successful execution of this statement, Oracle Database creates a text parameter file on the server. In an Oracle Real Application Clusters environment, it will contain all parameter settings of all instances. It will also contain any comments that appeared on the same line with a parameter setting in the server parameter file.

See Also:


You must have the SYSDBA or the SYSOPER role to execute this statement. You can execute this statement either before or after instance startup.



Description of create_pfile.gif follows
Description of the illustration create_pfile.gif



Specify the name of the text parameter file you want to create. If you do not specify pfile_name, then Oracle Database uses the platform-specific default initialization parameter file name.


Specify the name of the binary server parameter from which you want to create a text file.

See Also:

the appropriate operating-system-specific documentation for default parameter file names


Specify MEMORY to create a pfile using the current system-wide parameter settings. In a RAC environment, the created file will contain the contain the parameter settings from each instance.


Creating a Parameter File: Example The following example creates a text parameter file my_init.ora from a binary server parameter file s_params.ora:

CREATE PFILE = 'my_init.ora' FROM SPFILE = 's_params.ora';


Typically you will need to specify the full path and filename for parameter files on your operating system. Refer to your Oracle operating system documentation for path information.