global_name修改不生效

根据官网介绍的语法，修改global_name语法为

ALTER DATABASE RENAME GLOBAL_NAME TO 'xxx',

我的操作如下：

SQL>  select * from global_name; 

 

GLOBAL_NAME

--------------------------------------------------------------------------------

LWH.REGRESS.RDBMS.DEV.US.ORACLE.COM

 

SQL> alter database rename GLOBAL_NAME to lwh  ;

 

Database altered

 

SQL> select * from global_name;

 

GLOBAL_NAME

--------------------------------------------------------------------------------

LWH.REGRESS.RDBMS.DEV.US.ORACLE.COM

居然没变，我又执行下面的语句

SQL> ALTER DATABASE RENAME GLOBAL_NAME TO LWH.US.ORACLE.COM;

 

Database altered

 

SQL> select * from global_name;

 

GLOBAL_NAME

--------------------------------------------------------------------------------

LWH.US.ORACLE.COM

看样子如果是一个词组，会自动带上原来的后缀，如果是写上xx.xx.xx，只要带点，就能更新。最后我调整到 

SQL> ALTER DATABASE RENAME GLOBAL_NAME TO LWH.COM;

 

Database altered

 

SQL> select * from global_name;

 

GLOBAL_NAME

--------------------------------------------------------------------------------

LWH.COM

SQL> ALTER DATABASE RENAME GLOBAL_NAME TO LWH;

 

Database altered

 

SQL> select * from global_name;

 

GLOBAL_NAME

--------------------------------------------------------------------------------

LWH.COM

我不想带后缀。就是想变成“LWH",死活不成。

看了网上的介绍，可以用下面方法：

 

SQL> update global_name set global_name ='LWH';

 

1 row updated

SQL> select * from global_name;

 

GLOBAL_NAME

--------------------------------------------------------------------------------

LWH

真是费劲周折。修改为没有后缀的global_name 成功。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25027760/viewspace-732030/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25027760/viewspace-732030/