-
I have the database, how can I rename it without any problems, what are the steps for it?
Thank you.
-
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
-
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]
-
-
To add
service_name is only used in 8i onwards, but is same as db_name if db_domain is null.
Thanks
GP
-
[url]http://www.dbasupport.com/forums/showthread.php?threadid=5586[/url]
Reddy,Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|