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@xxxxxxxxxxxxxxx ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------