Oracle: Quick way to list all database links
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.
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
SELECT DB_LINK, USERNAME, HOST FROM ALL_DB_LINKSyou can try that, perhaps it can help you solve your problem
License under CC-BY-SA with attribution
Content dated before 6/26/2020 9:53 AM
dezso 8 years ago
Doesn't this return only the links available to the current user? Just for clarification...