This tip comes from Darl Kuhn, DBA at Sun Microsystems, in Broomfield, CO.
Description: Prior to Oracle9i Database Release 2, you were required to rebuild the controlfile to rename your database.
Now with Oracle9i Database Release 2, you can use the "nid" utility automates this task.
For example, if you want to change your database name to BRDSTN here are the steps:
1. Shutdown database
2. Startup mount
3. $ nid target=/ dbname=BRDSTN
4. Shutdown database
5. Change init.ora/spfile name, i.e.: initBRDSTN.ora
6. Change db_name parameter in init.ora/spfile, i.e.: db_name='brdstn'
7. Change ORACLE_SID to point to new database name
8. Startup mount
9. Alter database open resetlogs
10. Take a backup
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-84342/，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
