OraFAQ Forum: General » Creating PFILE from SPFILE.

Home » Other » General » Creating PFILE from SPFILE. (oracle 9.2.0.1.0 windows)

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

Creating PFILE from SPFILE. [message #477620]

Sat, 02 October 2010 09:22

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi,

Why I'm not able to do the below.

create PFILE <path> from SPFILE.

How to mention the path for SPFILE?

Thanks a lot...

Report message to a moderator

Re: Creating PFILE from SPFILE. [message #477621 is a reply to message #477620]

Sat, 02 October 2010 09:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You choose to ignore Posting Guidelines http://www.orafaq.com/forum/t/88153/0/, we choose to not answer.

Which part of the Posting Guidelines ( http://www.orafaq.com/forum/t/88153/0/ ) did you NOT read & follow?
Was it the part about using SEARCH ( http://www.orafaq.com/forum/s/136107/ ) or GOOGLE ( http://google.com ) before posting?
Why should we repeat here, what is already documented at http://tahiti.oracle.com
Please post DOCUMENTED solution back here after you have found it.

It works for me.

SQL> CREATE PFILE FROM SPFILE;

File created.

[Updated on: Sat, 02 October 2010 09:31]

Report message to a moderator

Re: Creating PFILE from SPFILE. [message #477622 is a reply to message #477621]

Sat, 02 October 2010 09:33

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

BlackSwan wrote on Mon, 27 September 2010 19:46

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

If you choose to ignore Posting Guidelines & requests for information, then we can choose to not answer your questions until you do so.

I concur.

Regards
Michel

Report message to a moderator

Re: Creating PFILE from SPFILE. [message #477662 is a reply to message #477622]

Sun, 03 October 2010 04:18

Frank
Messages: 7901
Registered: March 2000

Senior Member

Michel Cadot wrote on Sat, 02 October 2010 16:33

BlackSwan wrote on Mon, 27 September 2010 19:46
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

If you choose to ignore Posting Guidelines & requests for information, then we can choose to not answer your questions until you do so.

I concur.

Regards
Michel

Somehow I find these type of replies very funny, in a way they are definitely not meant to be: You guys DO know what "I will not reply" means, right?

Report message to a moderator

Re: Creating PFILE from SPFILE. [message #477664 is a reply to message #477662]

Sun, 03 October 2010 04:24

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You omit a (meaningful) part: "to your questions".

Regards
Michel

[Updated on: Sun, 03 October 2010 04:25]

Report message to a moderator

Re: Creating PFILE from SPFILE. [message #477668 is a reply to message #477664]

Sun, 03 October 2010 05:20

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Blackswan,

Read my question properly.

U posted the answer is worked with me also.

But my question was:

CREATE PFILE <path> FROM SPFILE.

Is there any other way to create a PFILE in a specific location?

Thanks

Report message to a moderator

Re: Creating PFILE from SPFILE. [message #477670 is a reply to message #477668]

Sun, 03 October 2010 05:41

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

We all (OP included) know by now that OP has trouble reading and understanding the documentation. So the quickest way to kill his threads is to give the answer:

jw> create pfile='c:\tmp\jw.pfile' from spfile;

File created.

jw>

Report message to a moderator

Re: Creating PFILE from SPFILE. [message #477671 is a reply to message #477668]

Sun, 03 October 2010 05:53

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Is there any other way to create a PFILE in a specific location?

What about reading the documentation we already pointed you to many and many times?

And what about reading the forum guide and following it?

Regards
Michel

[Updated on: Sun, 03 October 2010 05:54]

Report message to a moderator

Previous Topic:	Selection of particular DB
Next Topic:	information about oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 04:00:33 CST 2024