| Changing Instance Name [message #56005] |
Fri, 28 February 2003 12:04  |
lily
Messages: 44
Registered: September 2000
|
Member |
|
|
I have a 8.1.7 Instance called 'xxx' on sun. Can I change the Instance name? What needs to be done in order to change the Instance name to 'yyy' ? Thanks in advance.
lily.
|
|
|
|
| Re: Changing Instance Name [message #56015 is a reply to message #56005] |
Sun, 02 March 2003 01:59  |
Natthawut
Messages: 7
Registered: March 2002
|
Junior Member |
|
|
That will be a lot of work. I'm trying to list all the steps. The point is that you need to re-create new database by using existing configuration except database name.Do the following.
1) Use 'alter database backup control file to trace' to generate script for re-create database.
2)Modify the script somewhere in 'create database xxxx', change it to new name you like
3) Perhap you have to change any parameter in pfile that relate to your database name
4) Rename your pfile in accord with your database name.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
