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

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
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google