SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 12月 13 18:03:43 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>UPDATE global_name SET global_name='DEMO';
SQL>COMMIT;
更新完成之后 重启数据库
SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP
SQL>SELECT * FROM global_name;
GLOBAL_NAME
--------------------------------
DEMO
查看数据库连接
SQL> select db_link from dba_db_links;
DB_LINK
---------------------------------------------------
LINK_STAT1.REGRESS.RDBMS.DEV.US.ORACLE.COM
里面的DBLINK还是带有域名，重新建一个看看
SQL>CREATE DATABASE LINK link_test CONNECT TO user IDENTIFIED BY password USING 'DEMO';
再次查看
SQL> select db_link from dba_db_links;
DB_LINK
---------------------------------------------------
LINK_TEST
LINK_STAT1.REGRESS.RDBMS.DEV.US.ORACLE.COM
这说明要新建的数据连接才会取消域名后缀。
