Re: DB_NAME in init.ora

Steve Butler <sbut-is_at_seatimes.com> wrote:

>On Fri, 20 Oct 1995, Ken Huisman wrote:
>> I was wondering if it is actually possible to change the database name. If it
>> is, does anyone know how to do it? I know the name gets stuck in the
>> control files, data files, and redo logs, and you would have to change it in
 

>Only the control file -- see my other posting.

I tried to do this last week: I recreated a control file with a different name, and changed the name of the SID, and init.ora DB_NAME, before instance startup...but what about the database name that's stored in the DB file headers? I couldn't open the database because the DB_NAME in the control file didn't match the name in the DB file headers. Did I miss something in these posts? There's no mention of this problem.

Please enlighten me.

Paul Baumgartel, Principal Consultant              paulb_at_pcnet.com 
Adept Computer Associates, Inc.                                    
********************************************************************