Home / Errors/Workarounds10g / ORA-02082: a loopback database link must have a connection qualifier

ORA-02082: a loopback database link must have a connection qualifier

ERROR

ORA-02082: a loopback database link must have a connection qualifier


SQL>drop  public database link APPS;
drop  public database link APPS
                           *
ERROR at line 1:
ORA-02082: a loopback database link must have a connection qualifier

SOLUTION

Rename the global_name of the database before you can drop the database link.
SQL>select * from global_name;

GLOBAL_NAME
——————————————————————————–
APPS.EXAMPLE.COM

SQL>alter database rename global_name to TEST;
Database altered.

SQL>drop  public database link APPS;
Database link dropped.

SQL>alter database rename global_name to APPS;
Database altered.

SQL>select * from global_name;

GLOBAL_NAME
——————————————————————————–
APPS.EXAMPLE.COM

Reference: ORA-02082 TRYING TO DROP A PUBLIC DBLINK (Doc ID 1070826.6)

 

 

 

........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old

ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old More from my siteHow To …

Leave a Reply