Rename the existing database...

[yekaterina]

I have the database, how can I rename it without any problems, what are the steps for it?

Thank you.

[gpsingh]

ORACLE_SID or db_name

I think u ment ot say db_name,
Take Backup:
1)MAke sure no one is using the database
2)alter database backup controlfile to trace;
3)Edit this file and change database name to new one.NORESETLOGS to RESETLOGS.
4)change db_name in your init/config file
5)From svrmgrl , run this script.

Are you using global db_domain

Take Care
GP

[Halo]

In step 4:
-> Change db_name, service_name and instance_name in init.ora and/or config.ora
-
In step 5:
-> run script from svrmgrl @nomount to recreate the controlfile.
---
Suggestion:
Open the db after recreating the controlfile, shutdown the db and restart to make sure that it opens the db cleanly.

[Edited by Halo on 02-26-2001 at 03:49 PM]

[yekaterina]

Thank you!

[gpsingh]

To add
service_name is only used in 8i onwards, but is same as db_name if db_domain is null.

Thanks
GP

[sreddy]

[url]http://www.dbasupport.com/forums/showthread.php?threadid=5586[/url]