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

Such error occurs when there is a db link which is a loop back database link i.e. points to itself

Example:
SQL> DROP DATABASE LINK VELDB.WORLD;
DROP DATABASE LINK VELDB.WORLD
*
ERROR at line 1:
ORA-02082: a loopback database link must have a connection qualifier

— Shows the global name matches the db link
SQL> select * from global_name;
GLOBAL_NAME
—————————————————————————————————-
VELDB.WORLD
1 row selected.

solution:

SQL > Alter database rename global_name to TEMP.XXXX;
Database altered.

— After changing global name one is able to drop the database link and after dropping the database link you can rename the global names

SQL> DROP DATABASE LINK VELDB.WORLD;
Database link dropped.

SQL> Alter database rename global_name to VELDB.WORLD;
Database altered.

Velmurugan Ramasubbu