32

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.

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

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