修改global_name

修改global_name
两种方法:
1.UPDATE GLOBAL_NAME SET GLOBAL_NAME ='fox10g';

sys@FOX.REGRESS.RDBMS.DEV.US.ORACLE.COM> UPDATE GLOBAL_NAME SET GLOBAL_NAME ='fox10g';

1 row updated.

sys@FOX.REGRESS.RDBMS.DEV.US.ORACLE.COM> commit;

Commit complete.

sys@fox10g> select global_name from global_name
  2  ;

GLOBAL_NAME
----------------------------------------------------
----------------------------------------------------
----------------------------------------------------
----------------------------------------
fox10g
2.用rename的方式
alter database rename global_name to fox10g;
修改完,global_name会默认加上DB_DOMAIN

作者: lovegigi1999   发布时间: 2010-11-08