What is the use of spfile and init.ora in oracle? |
[Edit] |
init.ora and SPfile both contain information about DB parameters.
The database cannot start without an INIT.ORA but can start without an SPfile.
An SPfile cannot be edited directly , but one can be configured via the pfile (init.ora)
Init.ora is saved in ascii text format whereas the SPfile is saved in a binary format.
If both files exist , the database reads the SPfile first before processing the init.ora.
Oracle Guru's step in and correct if necessary .......... :)
,
Lekarshi
First answer by ID3412420354. Last edit by ID3412420354. Question popularity: 0 [recommend question]
|
Research your answer: |



