How to check for DB links

How to check Database links in Oracle Database


Execute this command as sysdba

SQL> select owner||','||db_link||','||username||','||host||','||created from dba_db_links;

After that you can check the status of DB links to know which DB links are working/not working

SQL>Select sysdate from dual@< DB_LINK> ;

 


Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."