Re: Changing a database name ?

Recent edition of Oracle magazine (mid 1997 ?) had ful instructions on this in it i believe.

Dominic baines

Bennett Leve wrote:

> Do you want to change the database name or the SID?
>
> If it is the SID that you want to change simply shut the database down
> and copy the $ORACLE_HOME/dbs/initSID.ora to
> $ORACLE_HOME/dbs/initNEW_SID.ora
> then change your environment variable "ORACLE_SID" to have the new SID
> name
> and start the database.
>
> If it is the db_name you wish to change then you will need to dump your
> control file out and recreate it. Let me know if this is what you want
> to do and I will send you some instructions.
>
> -Bennett
>
> Andries wrote:
> >
> > Does anybody know how to change the name of a already created database,
> > i am running oracle 7.3.2 on AIX
> > Any help would be appreciated.
> >
> > Andries
> >
> > ------------------------------------------------------------------------
> >
> > Andries <ahanekom_at_NOSPAMcoal.anglo.co.za>
> >
> > Andries
> > <ahanekom_at_NOSPAMcoal.anglo.co.za>
> > Netscape Conference Address
> > Netscape Conference DLS Server
> > To reply via e-mail remove NOSPAM from e-mail address
> > Additional Information:
> > Last Name
> > First Name Andries
> > Version 2.1
Received on Mon Jul 20 1998 - 06:42:13 CDT