Home » RDBMS Server » Server Administration » what is diff between "Create pfile from spfile and Create spfile from pfile"
what is diff between "Create pfile from spfile and Create spfile from pfile" [message #205753] Mon, 27 November 2006 06:29 Go to next message
sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore
Member

Hi all


what is differance between
Create pfile from spfile and Create spfile from pfile

when we have to use scenarios



Thanks in Advance
Sree
Re: what is diff between "Create pfile from spfile and Create spfile from pfile" [message #205754 is a reply to message #205753] Mon, 27 November 2006 06:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is self explanative.
When you want to create a pfile(which you can edit) from an existing and currently used spfile (Which you are not supposed to edit directly) , you can create a pfile from spfile and vice-versa.
Re: what is diff between "Create pfile from spfile and Create spfile from pfile" [message #205810 is a reply to message #205753] Mon, 27 November 2006 13:38 Go to previous messageGo to next message
TanteKaethe
Messages: 4
Registered: November 2006
Junior Member
sponguru_dba wrote on Mon, 27 November 2006 13:29
what is differance between
Create pfile from spfile and Create spfile from pfile

when we have to use scenarios




Difference PFILE and SPFILE:

SPFILE = Server Parameter File. The file is stored on the server. The file is binary format. ALTER SYSTEM command can update the SPFILE.

PFILE = The file is stored on the client (or from where the startup of the database is done). The file is text format. ALTER SYSTEM command never updates the PFILE.


=> use SPFILE and not PFILE!
=> plan to transform existing pfiles to spfiles ("Create spfile from pfile")

[Updated on: Mon, 27 November 2006 13:40]

Report message to a moderator

Re: what is diff between "Create pfile from spfile and Create spfile from pfile" [message #207075 is a reply to message #205753] Mon, 04 December 2006 01:40 Go to previous message
ora10g
Messages: 7
Registered: July 2006
Junior Member
we can edit spfile through oracle 10g database control.
Differenc between pfile and spfile
Previous Topic: crontab failure
Next Topic: droping the queue tables
Goto Forum:
  


Current Time: Fri Dec 02 20:31:12 CST 2016

Total time taken to generate the page: 0.11432 seconds