Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Editing pfile created from spfile
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
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