| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: More spfile goodness
No it's when Dan wants to celebrate his 40th birthday so he can fool
everyone into thinking he's younger than he is. Today is his 40th.
Ruth
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of jtesta_at_dmc-it.com
Sent: Thursday, May 06, 2004 2:01 PM
To: oracle-l_at_freelists.org
Subject: Re: More spfile goodness
Whats a catch-42, a catch-22 that's 20 years old?
now back to our regularly scheduled program.
joe
original message below
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.
Regards,
Daniel
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_at_optusnet.com.au
 |
 |