Toad for Oracle. How can I test a DB Link?
Go to Schema Browser | DB Links tab | highlight the DB Link name you want to test | then click on the “Test Database Link” icon (lightning bolt icon) | and it should give you the test results like below.
*********************************************************************
Link Name : "EXADB11GR2_DBLINK.RGRES.RDBMS.DEV.US.ORACLE.COM"
Connection : Successful
DB Name : DBM
DB Version : Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
*********************************************************************
