dblink&global_name
时间：2010-06-26 来源：rushmeplz
SQL> show parameter global_names;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
global_names boolean TRUE SQL> select * from global_name; GLOBAL_NAME
--------------------------------------------------------------------------------
ORCL SQL> select * from global_name@orcl1;
select * from global_name@orcl1
*
ERROR at line 1:
ORA-02085: database link ORCL1 connects to GC SQL> alter system set global_names=false; System altered. SQL> select * from global_name@orcl1; GLOBAL_NAME
--------------------------------------------------------------------------------
GC 加入db_domain后global_name的修改 SQL> update global_name set global_name='ORCL'; 1 row updated. SQL> commit; Commit complete.
------------------------------------ ----------- ------------------------------
global_names boolean TRUE SQL> select * from global_name; GLOBAL_NAME
--------------------------------------------------------------------------------
ORCL SQL> select * from global_name@orcl1;
select * from global_name@orcl1
*
ERROR at line 1:
ORA-02085: database link ORCL1 connects to GC SQL> alter system set global_names=false; System altered. SQL> select * from global_name@orcl1; GLOBAL_NAME
--------------------------------------------------------------------------------
GC 加入db_domain后global_name的修改 SQL> update global_name set global_name='ORCL'; 1 row updated. SQL> commit; Commit complete.
相关阅读 更多 +
