My experience also on Win2K. 9.2.0.1.0 the file is editable. On 9.2.0.3.0 results are unpredictable if you edit the file. I guess that they really don't want us editing it.
Kirtikumar Deshpande To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <kirtikumar_desh cc: pande Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in @yahoo.com> Sent by: ml-errors 07/16/2003 11:24 PM Please respond to ORACLE-L Keeping them binary gives them "power" I guses... On most platforms there is just a hashed value on the first line. In 9i R1 (9.0.1), I was able to replace some param value without changing number of chars on the line, and the changes were taken without any problem (HP-UX 11, it was I think). Could not believe that it worked. No such luck in 9i R2... Binary, text, whatever, I will just stay away from him till pfile really goes away :) - Kirti --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > it isn't binary on solaris ... pure text ... > > Raj > > -----Original Message----- > Sent: Wednesday, July 16, 2003 6:40 PM > To: Multiple recipients of list ORACLE-L > sync with INIT.ORA ?) > > > I can definitely appreciate the benefits of dynamic parameters, and of being > able to persist the values of those parameters accross shutdown/startup > cycles. But I would have guessed that oracle could have gotten both of > those features together without going to a binary parameter file--couldn't > whatever process writes to the spfile just write to a plain text file > instead? Does anybody know what the advantage of having a binary store of > params is? > > Cheers, > -Roy > > ********************************************************************This e-mail message is > confidential, intended only for the named recipient(s) above and may contain information that is > privileged, attorney work product or exempt from disclosure under applicable law. If you have > received this message in error, or are not the named recipient(s), please immediately notify > corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank > you. *********************************************************************2 > __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).