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
add comment

2 Answers

up vote 12 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
add comment
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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