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

Oracle Error Message

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

Reason for the Error

An attempt was made to create a database link with the same name as the current database.

Solution

a loopback database link needs a trailing qualifier, for example MYDB.EXAMPLE.COM@INST1 – the ‘@INST1’ is the qualifier