Re: spfile vs pfile in 9i

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 27 Oct 2004 06:52:46 +1000
Message-Id: <417eb90f$0$22631$afc38c87@news.optusnet.com.au>

Niall Litchfield wrote:

> "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
> news:417e6242$0$22672$afc38c87_at_news.optusnet.com.au...

>> And whatever happened to:
>>
>> create pfile from spfile
>> edit pfile
>> create spfile from pfile
>> startup
>> ??

>
> Neither your route, nor Holger's nor restoring a good copy over a corrupt
> one are difficult steps. I'd just argue that they add an extra (albeit
> trivial) level of tasks to the old
>
> edit pfile
> startup.
>
> routine using the old system.

Agree, though Pete Sharman used to tear me off a strip for saying it!

But whilst it's fine for you to edit a text file, we won't be able to have all the wonders of SQL Server.., er, I mean, a "self-tuning database", unless we let the instance edit it. Which means hello binary, good bye humans.

Regards
HJR Received on Tue Oct 26 2004 - 15:52:46 CDT