How to check dblink in oracle?
The title says it all, is there a way to quickly list all the current database links in oracle?
Something along the same lines as this, which lists the current user's tables:
select * from user_tables;
The answer to your question - how to check dblink in oracle is -
SELECT DB_LINK, USERNAME, HOST FROM ALL_DB_LINKS
you can try that, perhaps it can help you solve your problem