I created a db link using the following syntax:
SQL> create database link connect to identified by using ”;
But while trying to connect, I got ORA-02085 error.
ERROR at line 1:
ORA-02085: database link XXXX connects to YYYY
The name of the database link should match the global name of the target
database if GLOBAL_NAMES=TRUE. This may seem restricting since then there can
be only one database link per schema to a given database if global_names is
set to true. To overcome this use database link qualifiers. For example:
SQL> create database link oradb@link1
NOTE: in this example, ‘link1’ is database link qualifier
and ‘D:BOSTON-MFG’ is the connect string
‘@’ is reserved word and cannot be used for database link name ,
doing so in 11g results in ORA-02019 when trying to
select using the dblink.
The simple solution to above issue is to Set GLOBAL_NAMES value to FALSE.