修改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
阅读(844) | 评论(1) | 转发(0) |
