Re: init.ora file?

On Wed, 26 Feb 2003 21:21:49 +0000, Anurag Varma wrote:

> Howard,
>
> What do you mean by "teadious business of exporting it to an init.ora, editing the init.ora ..."?
>
> exporting is just issuing 'create pfile from spfile'. re-exporting is
>'create spfile from pfile'

So that's what I meant by 'exporting it to an init.ora'!

> Illegal values (if I understand what you mean by this)
> can come up in init.ora also .. which would need to be fixed also.

But since you can edit the init.ora directly, you don't have to sit there issuing commands to get the file into an editable state before fixing the problem. Nor issue commands to re-create the damn thing afterwards.

You have to do two extra bits of typing to fix the problem. I, with my humble init.ora, don't! That's all. Maybe claiming two bits of typing was 'tedious' was a teensy-weensy bit of hyperbole on my part!! I still find it a pain, though.

>
> Agreed that there is no major advantage in using spfile. I don't know if I agree with your disadvantage, after all I'd
> consider it a rare instance that an illegal value gets in there.

Then you are obviously a better typist than me, because I have on several occasions set shared_pool_size to zero by not hitting the '8' key hard enough.

Regards
HJR Received on Thu Feb 27 2003 - 12:46:35 CST