Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
1  
This is all documented in the manual: docs.oracle.com/cd/E11882_01/server.112/e25513/toc.htm –  a_horse_with_no_name Nov 6 '12 at 7:44
    
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 curernt user has access to •USER_DB_LINKS - All DB links owned by current user –  Juan Alvarez May 7 '13 at 22:29

2 Answers 2

up vote 15 down vote accepted

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 curernt user has access to
  • USER_DB_LINKS - All DB links owned by current user
share|improve this answer
    
That's perfect. Exactly what I was looking for, thanks. –  Clarkey Nov 14 '11 at 14:59
SELECT DB_LINK, USERNAME, HOST FROM ALL_DB_LINKS 

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

share|improve this answer
2  
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 at 6:09

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

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.