Re: More spfile goodness

From: <jtesta_at_dmc-it.com>
Date: Thu, 6 May 2004 14:00:46 -0400 (EDT)
Message-ID: <33817.155.188.255.3.1083866446.squirrel@www.dmc-it.com>

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

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu May 06 2004 - 13:11:40 CDT