Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Editing pfile created from spfile

RE: Editing pfile created from spfile

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Wed, 5 Apr 2006 21:45:57 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0BF93F9A@ENYC11P32005.corpny.csfb.com>


What's your database platform, and what editor are you using? I never had a problem editing pfiles produced on Windows.

Paul Baumgartel
paul.baumgartel_at_credit-suisse.com
212.538.1143

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Michael Ray Sent: Wednesday, April 05, 2006 4:42 PM
To: oracle-l_at_freelists.org
Subject: Editing pfile created from spfile

Oracle claims the create pfile from spfile command results in an ascii file, which technically is correct, but it's got special ascii characters so notepad or the like isn't suitable to edit it. I'll probably use a hex editor, but I wondered how exact I have to be on using these special characters around the static parameter I need to add. Has anybody had to edit one of these?

I was also annoyed that metalink said you could add a static parameter to the spfile if you limited the scope to spfile. I still got the 2095.

Shalom
--

http://www.freelists.org/webpage/oracle-l



Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html


--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 05 2006 - 15:45:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US