Re: Can I change the db name?

From: Mark Malakanov <markmal_at_sprint.ca>
Date: Sun, 4 Jul 1999 10:42:20 -0300
Message-ID: <QlKf3.2033$jl.11726365@newscontent-01.sprint.ca>

Sure.

1. MAKE FULL BACKUP BEFORE!

ALTER DATABASE RENAMEGLOBAL NAME TO database_name.domain_name.

It changes the global name of the database. The database_name is the new database name and can be as long as eight bytes. The optional domains specifies where the database is effectively located in the network hierarchy. Renaming your database automatically clears all data from the shared pool in the SGA. However, renaming your database does not change global references to your database from existing database links, synonyms, and stored procedures and functions on remote databases. Changing such references is the responsibility of the administrator of the remote databases.
<Oracle Doc>

Also you have to change db_name=oracle in init.ora. And you have to recreate controlfile. Attention - dangerous!

1. execute alter system backup controlfile to trace;
2. find trace file in user_dump directory
3. Edit database name
4. Execute this script.

Regards,
Mark Malakanov

PS/
I surprised, for what purposes do you need this things?

cantoneseboy <cantoneseboy_at_hotmail.com> wrote in message news:377F51A0.53276240_at_hotmail.com...
> Hi
>
> I know the same instance name can mount different database by
> editing the
> init<>.ora file. But can I change the db name where the database is
> created
> by the statement:
>
> create database <database name > ............
>
>
> Wayne
>
Received on Sun Jul 04 1999 - 08:42:20 CDT