How to create oracle database Pfile and Spfile ?
How to Create SPFILE from PFILE ?
The actual file names can also be specified in the create command.- Connect to Database using Sqlplus
SQL> create spfile from pfile;
How to Create PFILE from SPFILE ?
1. As a means of text-based backup.
2. For verifying and analyzing the values currently being used.
3. Modifying the export file and then recreating the SPFILE.
SQL> create pfile from spfile;
SQL> create pfile='initdb1.ora.bkp' from spfile;
SQL> create pfile='initdb2.ora.bkp' from spfile='spfiledb2.ora';
The actual file names can also be specified
in the create command. SQL> create spfile from pfile;
Tags: Oracle Database, Spfile
Subscribe to:
Post Comments (Atom)
Share your views...
0 Respones to "How to create oracle database Pfile and Spfile ?"
Post a Comment