Re: Renaming a Database

Tom,

        If I create a control file (new one) does the sys and system information stay intact or do I need to recreate them as well? I am assuming that I need to change the database name in the Init file and restart the database.

Thanks for your help,
Jimmy

Thomas Kyte wrote:
>
> CREATE CONTROLFILE
>
> Purpose
> To recreate a control file in one of the following cases:
>
> o All copies of your existing control files have been lost through
> media failure.
> o You want to change the name of the database.
> o You want to change the maximum number of redo log file
> groups, redo log file members, archived redo log files, data files,
> or instances that can concurrently have the database mounted
> and open.
>
>
> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Service Industries
> Reston, VA USA
>
> --
> http://govt.us.oracle.com/ -- downloadable utilities
>
> ----------------------------------------------------------------------------
> Opinions are mine and do not necessarily reflect those of Oracle Corporation

Received on Mon Mar 01 1999 - 10:06:32 CST