+ Reply to Thread
Results 1 to 5 of 5
  1. 03-12-2001 01:56 AM #1
    kmstan
    kmstan is offline Junior Member
    Join Date
    Mar 2001
    Posts
    11

    Question

    Is it possible to change the name of an instance on Windows NT platform without dropping and re-creating the instance?

    Thanks.
    Reply With Quote Reply With Quote
  2. 03-12-2001 04:05 AM #2
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?
    Reply With Quote Reply With Quote
  3. 03-12-2001 04:08 AM #3
    hrishy
    hrishy is offline Super Moderator
    Join Date
    Jan 2001
    Posts
    2,828
    in thsi case jurij do you ahve to edit the values in the registry
    Reply With Quote Reply With Quote
  4. 03-12-2001 08:55 AM #4
    soren
    soren is offline Junior Member
    Join Date
    Nov 2000
    Posts
    26

    Cool

    hi,
    oradim takes care of the registry entries, u need not do anything with the registry
    cheers
    soren
    Reply With Quote Reply With Quote
  5. 03-12-2001 02:07 PM #5
    yajman
    yajman is offline Junior Member
    Join Date
    Feb 2001
    Posts
    15
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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