Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
Date: Thu, 17 Jul 2003 08:45:44 -0500
Message-Id: <25946.338249@fatcity.com>


I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big (< 2 gig I think ) emacs (with certain options??) can be used.

The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them.

> -----Original Message-----
>
> it's a fake sort of binary -- try editing it with vi and then try
> opening your database with the spfile... but first make an init.ora
> copy of it.
>
> There is some sort of checksum going on, even though it looks like
Received on Thu Jul 17 2003 - 08:45:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US