December 2002
Intermediate to advanced
928 pages
85h 29m
English
CREATE PFILE
CREATE PFILE [= 'pfile_name'] FROM SPFILE [= 'spfile_name']
Creates a text file containing initialization parameters. New with Oracle9i Release 2.
Specifies the name of the output text file that will be created and that will contain parameter information in text form. If pfile_name is not specified, Oracle uses a platform-specific filename, usually INITsidORA.
Specifies the name of the existing binary server parameter file from which parameters will be written. If spfile_name is not specified, Oracle uses a platform-specific filename.