Re: DB_NAME in init.ora

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/11/21
Message-ID: <Pine.SUN.3.91.951121094106.16631A-100000_at_seatimes>#1/1

On Sun, 12 Nov 1995, Paul Baumgartel wrote:
> 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
>
> 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.
>

1. DESTROY (as in rm) the control files.
2. See the SET option in the create controlfile command.

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Tue Nov 21 1995 - 00:00:00 CET