Re: Control Files

craig walters wrote:
>
> Hi all,
> Is there a utility or way to see what the contents of the Oracle control
> file are? I can see a few things by opening a copy of a control file into
> wordpad, but because of the binary nature, I am not getting a complete
> picture. Any thoughts?
> Thanks,
> craig
> waltersc_at_mail.dec.com

Try

SQL> alter database backup controlfile to trace;

Oracle creates a trace file in a directory, defined by the user_dump_dest parameter in init<SID>.ora ( config<SID>.ora ) file.

Hope it helps

-- 
Alik Shapiro
Oracle DBA, EDS
Phone (317)240-7757
E-MAIL  :  fz1dmj_at_agt.gmeds.com

The above statements and opinions are my own and do not
necessarily represent those of EDS.