Saturday, February 9, 2013

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

When drop the database link, I get the error “ORA-02082: a loopback database link must have a connection qualifier”.

image

This is because the DB_LINK name is same as the GLOBAL_NAME.

SELECT * FROM GLOBAL_NAME;

image

All we need to do is change the GLOBAL_NAME to something else temporary.

image

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates