Changes to Oracle's Global_names

oracle10g after the installation is complete, the value of Global_name is not only ORCL, but also the domain name, and very long, difficult to remember. So think of ways to change the value of Global_name.

Conn/as SYSDBA

Show parameter global_name;

FALSE;

alter system set global_name=true;

Update Global_name set GLOBAL_NAME=ORCL;

Show parameter global_name;

SELECT * from Global_names;

I now want to change the value of global_names to something else, and more.

alter system set GLOBAL_NAMES=TEST1,TEST2,TEST3;

SELECT * from Global_names;

This article is from the "Common Documents" blog, so be sure to keep this source http://yujianglei.blog.51cto.com/7215578/1561899

Changes to Oracle's Global_names