Re: More spfile goodness

  • From: Daniel Fink <Daniel.Fink@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 06 May 2004 11:41:20 -0600

Ah, the chicken or the egg...

Control files are identified by the parameter (spfile/init.ora) file. If you
kept the parameters in the control file, how would the database know which
control files to read? And if a control file was lost? How would you edit the
control file to change the parameter to point to a different control file?

Sounds like a catch-42.

in sunny Denver, Colorado

Nuno Souto wrote:

> Why complicate things indeed?  If it had to be a binary file,
> it could well have been the control file as you suggest.
> All this spfile/pfile rigmarole is just an unnecessary
> and unwarranted complication.  But it's great to generate
> revenue out of OCP training...
> Cheers
> Nuno Souto
> in sunny Sydney, Australia
> dbvision@xxxxxxxxxxxxxxx

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: