DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Regarding service name Urgent!!!

  1. 06-22-2001, 02:18 AM #1
    shailendra
    shailendra is offline Senior Member
    Join Date
    Sep 2000
    Posts
    305
    In oracle your service name is like this
    databasename.domainname but i have given only database name I havn't give the doamin it was working fine but now I want to change it.
    Now I want to change it to databasename.domainname
    I do plz. help in it is very urgent

    Thanks in Advance
    Reply With Quote Reply With Quote
  2. 06-22-2001, 03:27 AM #2
    ales
    ales is offline Advisor
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    See command ALTER DATABASE RENAME GLOBAL_NAME TO new_name.new_domain in Oracle SQL Reference.
    You didn't write anything about version of Oracle, so as far I know the command exists since 8.1.5.
    Database mustn't be mounted when issuing the command and you also have to properly change initSID.ora file.
    Check docs carefully.
    Ales
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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