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;
Read More
Add your Comment
0
comments
What is Oracle database SPFILE ?
INTRODUCING the SPFILE
Oracle provides two different types of mutually exclusive
parameter files that you can use, PFILE and SPFILE. Let’s look at the SPFILE in a bit more detail.
Read More
Add your Comment
0
comments
