patternCritical
Oracle: Quick way to list all database links
Viewed 0 times
allwaydatabaselinksquicklistoracle
Problem
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:
Thanks,
GC.
Something along the same lines as this, which lists the current user's tables:
select * from user_tables;Thanks,
GC.
Solution
These views are helpful for working with DB links in Oracle:
See more in Oracle documentation
- 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
Context
StackExchange Database Administrators Q#7861, answer score: 54
Revisions (0)
No revisions yet.