I have the database, how can I rename it without any problems, what are the steps for it?
ORACLE_SID or db_name
I think u ment ot say db_name,
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
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.
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]
service_name is only used in 8i onwards, but is same as db_name if db_domain is null.
Click Here to Expand Forum to Full Width