{"id":1827,"date":"2018-11-17T14:16:05","date_gmt":"2018-11-17T06:16:05","guid":{"rendered":"http:\/\/www.821121.com\/?p=1827"},"modified":"2022-11-17T14:50:04","modified_gmt":"2022-11-17T06:50:04","slug":"oracle-dblink","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1827","title":{"rendered":"Oracle dblink"},"content":{"rendered":"

1.\u4ec0\u4e48\u662fdblink<\/h3>\n

dblink\u5728\u4e00\u4e2a\u6570\u636e\u5e93\u4e2d\u8bbf\u95ee\u53e6\u4e00\u4e2a\u6570\u636e\u5e93\u5efa\u7acb\u8d77\u6765\u7684\u901a\u9053\u3002<\/p>\n

dbLink\u662f\u7b80\u79f0\uff0c\u5168\u79f0\u662fdatabaselink\uff0c\u7ffb\u8bd1\u8fc7\u6765\u5c31\u662f\u6570\u636e\u5e93\u94fe\u63a5\u7684\u610f\u601d\u3002\u5b83\u4e3b\u8981\u662f\u7528\u6765\u505a\u8de8\u5e93\u8bbf\u95ee\u7684\u3002\u6bd4\u5982\u8bf4\u6211\u73b0\u5728\u6709\u4e00\u4e2aA\u6570\u636e\u5e93\uff0c\u8fd8\u6709\u4e00\u4e2aB\u6570\u636e\u5e93\uff0c\u90a3\u6211\u6211\u73b0\u5728\u60f3\u5728A\u5e93\u4e2d\u8bbf\u95eeB\u6570\u636e\u5e93\u4e2d\u7684\u6570\u636e\uff0c\u5c31\u53ef\u4ee5\u5728A\u5e93\u4e2d\u521b\u5efa\u4e00\u4e2adblink\u6765\u94fe\u63a5\u5230B\u6570\u636e\u5e93\u3002\u8fd9\u6837\u6211\u4eec\u5728A\u6570\u636e\u5e93\u4e2d\u5c31\u53ef\u4ee5\u76f4\u63a5\u5bf9B\u4e2d\u7684\u6570\u636e\u8fdb\u884c\u67e5\u8be2\uff0c\u8bbf\u95ee\uff0c\u4fee\u6539\u3002<\/p>\n

2.\u8bed\u6cd5\uff1a<\/h3>\n
CREATE PUBLIC DATABASE LINK db_link_name CONNECT TO username IDENTIFIED BY password USING '(DESCRIPTION =\n    (ADDRESS_LIST =\n      (ADDRESS = (PROTOCOL = TCP)(HOST =visist_IP)(PORT =visit_port ))\n    )\n    (CONNECT_DATA =\n      (SERVICE_NAME = db_name)\n    )\n  )';\n  --\u53c2\u6570\u8bf4\u660e\n  --username \u9700\u8981\u8bbf\u95ee\u6570\u636e\u7528\u6237\u540d\uff0c password  \u5bc6\u7801\uff0c \n  visit_ip  \u9700\u8981\u8bbf\u95ee\u6570\u636e\u5e93\u7684ip\uff0cvisit_port \u7a97\u53e3\uff0c \n  db_name\u6570\u636e\u5e93\u540d\u79f0<\/code><\/pre>\n
3.\u4f8b\u5b50\uff1a<\/h3>\n
241\u7684dsdta\u548cdsdemo\u7528\u6237\u53ef\u4ee5\u8bbf\u95ee196\u7684linkdb\u7684\u6240\u6709\u8868<\/p>\n
241\u6267\u884c\ncreate public database link  to_196orcl connect to linkdb identified by linkdb using 'orcl';\n\norcl =\n  (DESCRIPTION =\n    (ADDRESS_LIST =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.196)(PORT = 1577))\n    )\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = orcl)\n    )\n  )<\/code><\/pre>\n
196 linkd \u53ef\u4ee5\u8bbf\u95ee241 dsdta\u548cdsdemo\u7684ooeg_t,ooefl_t,faah_t,faaj_t,inag_t,imaal_t\u7684\u8868\u67e5\u8be2\u6743\u9650<\/p>\n
241\u6267\u884c\ncreate user linkdb identified by "linkdb!241";\ngrant connect,resource to linkdb;\ngrant select on DSDEMO.FAAH_T to linkdb;\ngrant select on DSDEMO.FAAJ_T to linkdb;\ngrant select on DSDEMO.IMAAL_T to linkdb;\ngrant select on DSDEMO.INAG_T to linkdb;\ngrant select on DSDEMO.OOEFL_T to linkdb;\ngrant select on DSDEMO.OOEG_T to linkdb;\ngrant select on DSDATA.FAAH_T to linkdb;\ngrant select on DSDATA.FAAJ_T to linkdb;\ngrant select on DSDATA.IMAAL_T to linkdb;\ngrant select on DSDATA.INAG_T to linkdb;\ngrant select on DSDATA.OOEFL_T to linkdb;\ngrant select on DSDATA.OOEG_T to linkdb;<\/code><\/pre>\n
196\u6267\u884c\ncreate public database link  to_241 connect to linkdb identified by "linkdb!241" using 'topprd';\ntopprd =\n (DESCRIPTION =\n   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.242)(PORT = 1521))\n   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.244)(PORT = 1521))\n   (CONNECT_DATA =\n    (SERVER = DEDICATED)\n    (SERVICE_NAME = topprd)\n    )\n  )<\/code><\/pre>\n
\u5982\u679c\u60f3\u8981\u8d4b\u4e88\u66f4\u591a\u7684\u6743\u9650\uff0c\u53ef\u4ee5<\/p>\n
grant insert,update,delete on \u8868\u540d to \u7528\u6237\u540d<\/code><\/pre>\n
\u901a\u8fc7\u8d4b\u4e88\u8fde\u63a5\u7684\u7528\u6237\u6743\u9650\u6765\u5b9e\u73b0\u5bf9\u8868\u7684\u4e00\u7cfb\u5217\u64cd\u4f5c\uff0c\u8fd9\u6837\u66f4\u52a0\u7684\u5b89\u5168\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
1.\u4ec0\u4e48\u662fdblink dblink\u5728\u4e00\u4e2a\u6570\u636e\u5e93\u4e2d<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1827","post","type-post","status-publish","format-standard","hentry","category-34"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1827","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1827"}],"version-history":[{"count":2,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1827\/revisions"}],"predecessor-version":[{"id":1829,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1827\/revisions\/1829"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1827"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}