RE: How to edit spfile ?/

• "Reidy, Ron" <Ron.Reidy_at_arraybiopharma.com> wrote:
  > No. The spfile is binary. On *nix, you can do this:
  > $ strings spfileSID.ora > initSID.ora
  >
  > And then edit the init file using any text editor you would like.
  >
  > You might be able to use sed or possibly perl (reading and writing in
  > binary mode). However, I have never tried this, so you will need to
  > test this out.
  >
  

strings/sed works fine - I documented the process here:

   http://p010.hashjoin.com/hj/srwpkg.indx?p_sr_id=641&p_what=pview_sr

I could copy/paste here but I get to pimp my Knowledge Base so why not :-)

you'll need to create an account on http://www.hashjoin.com use the following KEY:

   1107781110

It's free and a good place to collaborate.

Regards,
- Vitaliy

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