Friday, September 12, 2014

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