How to Change global_name in a database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to Change global_name in a database

  1. #1
    Join Date
    Aug 2000
    Posts
    30
    Hi,

    I have my global_name as 'SALES'(when I am quering SELECT * FROM GLOBAL_NAME), I want to change the same to 'SALES.DEMO.CHEN.COM'. How to do it?

    Thanks in Advance.
    Regards,
    Jee

    Share on Google+

  2. #2
    Join Date
    Feb 2001
    Posts
    125
    Hi,

    GLOBAL_NAME can be renamed using
    Alter database command.

    systax is

    ALTER DATABASE RENAME GLOBALNAME TO


    For detail please. reference Oracle Documentation
    Oracle Sql Rerefece/ DBA


    Thanks

    P. Soni
    Share on Google+

  3. #3
    Join Date
    Feb 2001
    Posts
    389
    Before that db_domain has to be set in your init.ora file and for others to connect to it , in listener and tnsnames and sqlnet.ora files.
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width