How to rename the database

[JASMILLU]

Could any body tell me how to rename the database.

Thanks in Advance


Jas

[piyush]

use the following command:

ALTER DATABASE RENAME TO

[rameshch]

i dont think so we can change the database name once it is created but the only think we can do is change the dbname if it is a part of domain by this command
alter database db-name global rename to domainname.db-name ;
correct me if i am wrong

[hrishy]

Hello

i think you have posted the query in the wrong forum.

comming back to your question to rename a database.backup your control file .

alter database backup controlfile to trace.....
edit this controlfile to change the name of the database.
now use startup command...and you have sucessfully renmaed your database.

be careful to take a complete backup of your database before you attempt this.

regards
Hrishy

[ngwh]

ok what i did :

1)alter database backup controlfile to trace;
2)edit that trace file replacing "reuse" with "set" as well as
"noresetlogs" to resetlogs"...of course make sure your new dbname is changed.
3)chg ur init.ora
4)remove the "recover database ..." in the trace file then run it!

it should work!

rgds,

[julian]

Concerning renaming a database, check Metalink Doc ID: 61590.1