Friday, 6 July 2012

Oracle: How to check for DB links

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> ;

No comments:

Post a Comment

Number of Visitors