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 TESTDB.WORLD;
DROP DATABASE LINK TESTDB.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
—————————————————————————————————-
TESTDB.WORLD
1 row selected.


-- So to fix the issue rename the global_name to something else

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 TESTDB.WORLD;
Database link dropped.
SQL> Alter database rename global_name to TESTDB.WORLD;
Database altered.


Comments