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).
