Re: Manipulate Control Files

Dave Mausner wrote:
>
> In article <326a7b02.4441140_at_news.visi.com>,
> choang_at_visi.com (Carl Hoang) wrote:
> >Is there a way to manipulate control files? I've heard that it can be
> >converted to ASCII file for chaning and convert back to binary. Is
> >this possible and where can I find this info? TIA.
>
> yes, it is in the sql reference. look for ALTER SYSTEM DUMP CONTROLFILE TO
> TRACE. ^^^^^^^^^^^
>
> --
> Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.

        I could not find any reference for this command in "Oracle 7 Server Sql Reference" pages 4-71 to 4-82 (ALTER SYSTEM). Futhermore, I have never heard about this command.

        I would suggest to use command :
alter database backup controlfile to trace

        If dump destinatination is deafault, it will create an ASCII file in $ORACLE_HOME/rdbms/log trace file which can be recognized by process # (in UNIX) or simpler - by creation date.

	Hope it helps,
	Eugene.

-- 
********************************************************
*        Everything above is only my opinion           *
********************************************************
*						       *
* If you see a lion in a cage and sign says "elephant" * 
*                      ,                               *
*           DO not belive your eyes !                  *
*       (Kozma Prutkov. (informal translation))        *
*                                                      *
********************************************************