dblink名字后面有字符串REGRESS.RDBMS.DEV.US.ORACLE.COM

来源：互联网发布：淘宝网包包新款编辑：程序博客网时间：2024/05/29 06:51

SQL>  select * from global_name;GLOBAL_NAME--------------------------------------------------------------------------------ORCLSQL> create database link to_orcl2 connect to sys identified by oracle using 'ORCL2'; Database link created.

SQL> select * from dba_db_links;OWNER------------------------------------------------------------DB_LINK--------------------------------------------------------------------------------USERNAME------------------------------------------------------------HOST--------------------------------------------------------------------------------CREATED-------------------SYSTO_ORCL2SYS2016-02-19 03:03:18

SQL> drop  database link to_orcl2;Database link dropped.SQL>  alter database rename global_name to  ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM;Database altered.SQL> create database link to_orcl2 connect to sys identified by oracle using 'ORCL2'; Database link created.SQL> select * from dba_db_links;OWNER------------------------------------------------------------DB_LINK--------------------------------------------------------------------------------USERNAME------------------------------------------------------------HOST--------------------------------------------------------------------------------CREATED-------------------SYSTO_ORCL2.REGRESS.RDBMS.DEV.US.ORACLE.COMSYS

看来和 global_name 有关

0 0