Re: Changing a database name ?

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 Fri Jul 17 1998 - 19:13:58 CDT