`dblink\u521b\u5efa\uff0c\u67e5\u8be2\uff0c\u5220\u9664\uff0c
\nselect owner,object_name from dba_objects where object_type='DATABASE LINK';--\u67e5\u8be2\u73b0\u6709\u7684DBLINK
\n1\uff1a\u521b\u5efadblink\uff1a<\/p>\n
create public database link hr_cf_link
\nconnect to hruser IDENTIFIED BY hruser
\nusing '(DESCRIPTION =
\n(ADDRESS_LIST =
\n(ADDRESS = (PROTOCOL = TCP)(HOST =134.64.105.1)(PORT = 1521))
\n)
\n(CONNECT_DATA =
\n(SERVICE_NAME = ahtest)
\n)
\n)'; <\/p>\n
\u5df2\u77e5\u8fdc\u7a0b\u8868a<\/p>\n
2\uff1a\u67e5\u8be2\uff1a<\/p>\n
select * from a@ link hr_cf_link ;\/\/\u67e5\u8be2\u5bf9\u65b9\u8868\u8981\u7528\u8868\u660e\uff0c\u52a0\u4e0a@\uff0c\u52a0\u4e0adiblink\u94fe\u63a5\u540d\uff1alink hr_cf_link
\n\u5bf9\u8fdc\u7a0b\u8868\u7684\u67e5\u8be2\u3002<\/p>\n
3\uff1a\u521b\u5efa\u540c\u4e49\u8bcd<\/p>\n
CREATE SYNONYM hr_tocfuser FOR a@hr_cf_link;<\/p>\n
\u540c\u4e49\u8bcd\u521b\u5efa\u540e\uff0c\u6211\u4eec\u4ee5\u8fdb\u884c\u5982\u4e0b\u8fdb\u884c\u6570\u636e\u67e5\u8be2<\/p>\n
select * from hr_tocfuser;\/\/\u6765\u67e5\u8be2\u8fdc\u7a0b\u8868<\/p>\n
4\uff1a\u5220\u9664dblink<\/p>\n
drop public database link hr_cf_link ;<\/p>\n
5:\u5220\u9664\u540c\u4e49\u8bcd<\/p>\n
drop synonym \u300a\u540c\u4e49\u8bcd\u540d\u79f0\u300b
\n`<\/p>\n","protected":false},"excerpt":{"rendered":"
`dblink\u521b\u5efa\uff0c\u67e5\u8be2\uff0c\u5220\u9664\uff0c select owner,object_name from dba_objects where object_type=’DATABASE LINK’;–\u67e5\u8be2\u73b0\u6709\u7684DBLINK 1\uff1a\u521b\u5efadblink\uff1a create public database link hr_cf_link connect to hruser IDENTIFIED BY hruser using ‘(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =134.64.105.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ahtest) ) )’; \u5df2\u77e5\u8fdc\u7a0b\u8868a 2\uff1a\u67e5\u8be2\uff1a select * from a@ link hr_cf_link ;\/\/\u67e5\u8be2\u5bf9\u65b9\u8868\u8981\u7528\u8868\u660e\uff0c\u52a0\u4e0a@\uff0c\u52a0\u4e0adiblink\u94fe\u63a5\u540d\uff1alink hr_cf_link \u5bf9\u8fdc\u7a0b\u8868\u7684\u67e5\u8be2\u3002 3\uff1a\u521b\u5efa\u540c\u4e49\u8bcd CREATE SYNONYM hr_tocfuser FOR a@hr_cf_link; \u540c\u4e49\u8bcd\u521b\u5efa\u540e\uff0c\u6211\u4eec\u4ee5\u8fdb\u884c\u5982\u4e0b\u8fdb\u884c\u6570\u636e\u67e5\u8be2 select * from hr_tocfuser;\/\/\u6765\u67e5\u8be2\u8fdc\u7a0b\u8868 4\uff1a\u5220\u9664dblink drop public database link hr_cf_link ; 5:\u5220\u9664\u540c\u4e49\u8bcd drop synonym \u300a\u540c\u4e49\u8bcd\u540d\u79f0\u300b `<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[88,82],"tags":[],"class_list":["post-1571","post","type-post","status-publish","format-standard","hentry","category-oracle","category-82"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1571","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1571"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1571\/revisions"}],"predecessor-version":[{"id":1572,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1571\/revisions\/1572"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}