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.

  • David Mann

    David Mann Correct answer

    9 years ago

    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


    you can try that, perhaps it can help you solve your problem

    Doesn't this return only the links available to the current user? Just for clarification...

License under CC-BY-SA with attribution

Content dated before 6/26/2020 9:53 AM