启用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