OraFAQ Forum: Server Administration » what is diff between "Create pfile from spfile and Create spfile from pfile"

Home » RDBMS Server » Server Administration » what is diff between "Create pfile from spfile and Create spfile from pfile"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what is diff between "Create pfile from spfile and Create spfile from pfile" [message #205753]

Mon, 27 November 2006 06:29

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

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

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

ora10g
Messages: 7
Registered: July 2006

Junior Member

we can edit spfile through oracle 10g database control.
Differenc between pfile and spfile

Report message to a moderator

Previous Topic:	crontab failure
Next Topic:	droping the queue tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:52:42 CDT 2024