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.

相关阅读更多 +