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.
GLOBAL_NAME can be renamed using
Alter database command.
ALTER DATABASE RENAME GLOBALNAME TO
For detail please. reference Oracle Documentation
Oracle Sql Rerefece/ DBA
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.
Click Here to Expand Forum to Full Width