dblink&global_name

SQL> show parameter global_names;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
global_names                         boolean     TRUE

 

SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
ORCL

 

SQL> select * from ;
select * from
                          *
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
--------------------------------------------------------------------------------
GC

 

加入db_domain后global_name的修改

 

SQL> update global_name set global_name='ORCL';

1 row updated.

SQL> commit;

Commit complete.