database link能看link过来的表结构吗？

Question

database link能看link过来的表结构吗？能看link对方有什么表吗？

Answer 1

去掉“吧”chennan@cwgl94>desc bas_corp@link201
 名称                                                                是否为空? 类型
 ------------------------------------------------------------------- -------- --------------
 CORP_ID                                                             NOT NULL NUMBER(38)
 DISTRICT_ID                                                         NOT NULL NUMBER(38)
 CORP_CODE                                                           NOT NULL VARCHAR2(30)
 CORP_NAME                                                           NOT NULL VARCHAR2(100)
 CORP_SNAME                                                                   VARCHAR2(100)
 BANKNAME                                                                     VARCHAR2(100)
 BANKACCNO                                                                    VARCHAR2(200)
 TAXNO                                                                        VARCHAR2(200)
 ADDRESS                                                                      VARCHAR2(200)
 ZIP                                                                          VARCHAR2(6)
 EMAIL                                                                        VARCHAR2(100)
 LINKMAN                                                                      VARCHAR2(200)
 INNERPHONE                                                                   VARCHAR2(100)
 OUTERPHONE                                                                   VARCHAR2(100)
 CORP_PARE_ID                                                                 NUMBER(38)
 CORP_LVLSEQ                                                                  NUMBER(14)
 CORP_UNIFCODE                                                                VARCHAR2(30)
 CORP_INTECODE                                                                VARCHAR2(30)chennan@cwgl94>

Answer 2

能看link对方有什么表或对象吗？

Answer 3

select * from dict@link201
...跟本地操作一样，就是在表名最后加上@linkxxx即可