-
Is it possible to change the name of an instance on Windows NT platform without dropping and re-creating the instance?
Thanks.
-
Use utility oradim.exe. It allows you to rename the instance, it also renames appropriate service(s).
ORADIM -EDIT -SID myoldsid -NEWSID mynewsid ....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
in thsi case jurij do you ahve to edit the values in the registry
-
hi,
oradim takes care of the registry entries, u need not do anything with the registry
cheers
soren
-
If your Oracle version is 8.0 then,
ORADIM80 -EDIT -SID <oldsidname> -NEWSID <newsidname>
If your Oracle version is 8i then
ORADIM -EDIT -SID <oldsidname> -NEWSID <newsidname>
Actually the utility ORADIM(80) can be used to create, modify or to delete the instances.
If you want any help, just give,
ORADIM -help
All the best,
Yajman
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
|