How to Change global_name in a database

[jee]

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

[PSoni]

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

[gpsingh]

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.