28

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;

Thanks, GC.

38

These views are helpful for working with DB links in Oracle:

  • DBA_DB_LINKS - All DB links defined in the database
  • ALL_DB_LINKS - All DB links the current user has access to
  • USER_DB_LINKS - All DB links owned by current user

See more in Oracle documentation

2
SELECT DB_LINK, USERNAME, HOST FROM ALL_DB_LINKS 

you can try that, perhaps it can help you solve your problem

  • 3
    Doesn't this return only the links available to the current user? Just for clarification... – dezso Nov 6 '12 at 10:00

protected by Paul White Jul 3 '14 at 6:09

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.