修改global_name
时间:2010-11-08 来源:lovegigi1999
修改global_name
两种方法:
1.UPDATE GLOBAL_NAME SET GLOBAL_NAME ='fox10g';
[email protected]> UPDATE GLOBAL_NAME SET GLOBAL_NAME ='fox10g';
1 row updated.
[email protected]> 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
两种方法:
1.UPDATE GLOBAL_NAME SET GLOBAL_NAME ='fox10g';
[email protected]> UPDATE GLOBAL_NAME SET GLOBAL_NAME ='fox10g';
1 row updated.
[email protected]> 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
相关阅读 更多 +