HiveBrain v1.2.0
Get Started
← Back to all entries
patternCritical

Oracle: Quick way to list all database links

Submitted by: @import:stackexchange-dba··
0
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:

select * from user_tables;

Thanks,
GC.

Solution

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

Context

StackExchange Database Administrators Q#7861, answer score: 54

Revisions (0)

No revisions yet.