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