RE: Editing pfile created from spfile

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Wed, 5 Apr 2006 13:47:47 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD06FE682@ex2.ms.polyserve.com>

 >>>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?

try this (works like a charm):

$ strings - spfile.ora > pfile.ora

Notepad? Ahhh, windows...use cygwin or mks strings command

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

Received on Wed Apr 05 2006 - 15:47:47 CDT