查询:
SELECT * FROM worker@test_linkFROM 后的以你的实际为准

解决方案 »

  1.   

    刚才是我误解了你的意思了。你看这个对你有无帮助??
    是在sys.link$表里
    SQL> desc sys.link$;
     名称                                      空?      类型
     ----------------------------------------- -------- ---------------------------- OWNER#                                    NOT NULL NUMBER
     NAME                                      NOT NULL VARCHAR2(128)
     CTIME                                     NOT NULL DATE
     HOST                                               VARCHAR2(2000)
     USERID                                             VARCHAR2(30)
     PASSWORD                                           VARCHAR2(30)
     FLAG                                               NUMBER
     AUTHUSR                                            VARCHAR2(30)
     AUTHPWD                                            VARCHAR2(30)SQL> select name from sys.link$;NAME
    --------------------------------------------------------------------------------DT_DRV.US.ORACLE.COM
    DT_VEH.US.ORACLE.COM