Home » Other » General » Creating PFILE from SPFILE. (oracle 9.2.0.1.0 windows)
Creating PFILE from SPFILE. [message #477620] Sat, 02 October 2010 09:22 Go to next message
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...
Re: Creating PFILE from SPFILE. [message #477621 is a reply to message #477620] Sat, 02 October 2010 09:23 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Creating PFILE from SPFILE. [message #477662 is a reply to message #477622] Sun, 03 October 2010 04:18 Go to previous messageGo to next message
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?
Re: Creating PFILE from SPFILE. [message #477664 is a reply to message #477662] Sun, 03 October 2010 04:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: Creating PFILE from SPFILE. [message #477670 is a reply to message #477668] Sun, 03 October 2010 05:41 Go to previous messageGo to next message
John Watson
Messages: 8922
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>
Re: Creating PFILE from SPFILE. [message #477671 is a reply to message #477668] Sun, 03 October 2010 05:53 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Thu Mar 28 07:45:52 CDT 2024