启用global_name:

SQL> show parameter global_nameNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------global_names                         boolean     FALSESQL> alter system set global_names=true scope=both;System altered.SQL> show parameter global_nameNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------global_names                         boolean     TRUE

修改global_name:

SQL> select * from global_name;GLOBAL_NAME--------------------------------------------------------------------------------ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COMSQL> alter database rename global_name to orcl.com2  ;Database altered.SQL> select * from global_name;GLOBAL_NAME--------------------------------------------------------------------------------ORCL.COM