dbadblinks view lists all database links in database - Administering and Managing an Oracle Database

Q.  Which view lists all database links in the database?
- Published on 29 Jul 15

a. dba_db_links
b. all_db_links
c. user_db_links
d. dba_link

ANSWER: dba_db_links
 

    Discussion

  • Nirja Shah   -Posted on 27 Aug 15
    - The data dictionary of each database stores the definitions of all the database links in the database.

    - You can use data dictionary tables and views to gain information about the links.

    - The following views show the database links that have been defined at the local database and stored in the data dictionary:

    1. DBA_DB_LINKS - It lists all database links in the database.
    2. ALL_DB_LINKS - It lists all database links accessible to the connected user.
    3. USER_DB_LINKS - It lists all database links owned by the connected user.

    - The DB_LINK is one of the basic information about the database links.

    - DB_LINK - It is the name of the database link.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)