• 2067阅读
  • 0回复

数据库连接 取消后缀为REGRESS.RDBMS.DEV.US.ORACLE.COM的域名 [复制链接]

上一主题 下一主题
离线韭菜
 

只看楼主 倒序阅读 0楼 发表于: 2010-07-07
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

这说明要新建的数据连接才会取消域名后缀。
grant all privileges on *.* to 'a'@'localhost' identified by 'a' with grant option;flush privileges;
快速回复
限100 字节
 
上一个 下一个