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)