Fix DB Link Error ORA-02085: database link connects to

advertisements

_____________________________________________________________________________________________________________________

Problem Description:

Select from database link failing with following error

SQL> select 1 from dual@PRODDB1;

select 1 from dual@PRODDB1

                   *

ERROR at line 1:

ORA-02085: database link PRODDB1 connects to TEST3E

Solution Description:

Easiest way to resolve this issue is set GLOBAL_NAMES parameter value to false.

SQL> alter system set global_names=false scope=both sid='*';

System altered.

SQL> SELECT 1 FROM DUAL@PRODDB1;

         1

----------

         1

_____________________________________________________________________________________________________________________

Website Stats