顯示已建立的 DB Link

2013-08-20 17:40
SQL> column OBJECT_NAME format a20
SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE,STATUS from dba_objects where object_type='DATABASE LINK';
 
OWNER                          OBJECT_NAME          OBJECT_TYPE         STATUS
------------------------------ -------------------- ------------------- -------
STRADM                         ORCLS                DATABASE LINK       VALID