-
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
-
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
-
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.
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
|