{"id":960,"date":"2021-06-08T15:40:22","date_gmt":"2021-06-08T07:40:22","guid":{"rendered":"http:\/\/www.haoht.com.cn\/?p=960"},"modified":"2021-06-29T11:58:13","modified_gmt":"2021-06-29T03:58:13","slug":"%e5%b0%86%e6%89%80%e6%9c%89%e4%ba%ba%e5%91%98%e9%83%bd%e5%bc%80%e9%80%9a%e7%bd%91%e7%9b%98%e5%8a%9f%e8%83%bd","status":"publish","type":"post","link":"http:\/\/www.haoht.com.cn\/960\/","title":{"rendered":"\u5c06\u6240\u6709\u4eba\u5458\u90fd\u5f00\u901a\u7f51\u76d8\u529f\u80fd"},"content":{"rendered":"<p>\u5c06\u6240\u6709\u4eba\u5458\u90fd\u5f00\u901a\u7f51\u76d8\u529f\u80fd\uff0c\u6570\u636e\u5e93\u9700\u8981\u5728 Oiorg\u4e0a\u8fd0\u884c\uff0c\u7cfb\u7edf\u652f\u6301\u00a0MSSql\u53caOracle\u6570\u636e\u5e93<\/p>\n<p>&#8212; \u5c06\u76ee\u524doiorg\u8868\u5185\u5df2\u6709\u7684\u7528\u6237 \u5168\u90e8\u5f00\u901a\u7f51\u76d8<\/p>\n<p>&#8212; \u521b\u5efa\u6570\u636e\u5e93\u8fde\u63a5<br \/>\nCreate Database link DBLink_Org<br \/>\nconnect to amuser identified by Am123123<br \/>\nusing &#8216;127.0.0.1:1521\/OIOrg&#8217;;<\/p>\n<p>&nbsp;<\/p>\n<p>INSERT INTO OI_ND_USER ( CN_S_OWNER_ID, CN_S_OWNER_NAME, CN_C_ACTIVE,<br \/>\nCN_N_NETDISK_CAPACITY, CN_N_NETDISK_USED,<br \/>\nCN_N_NDX, CN_S_BAK,<br \/>\nCN_T_LAST_LIST_SHAREIN, CN_T_CREATE,<br \/>\nCN_G_UNIT_ID, CN_S_UNIT_NAME,<br \/>\nCN_C_CLEAN )<br \/>\nSELECT S_C1, S_C2, &#8216;Y&#8217;,<br \/>\n10737418240, 0,<br \/>\n0, &#8221;,<br \/>\nNULL, sysdate,<br \/>\n&#8216; &#8216;, &#8216; &#8216;,<br \/>\n&#8216;N&#8217;<br \/>\nFROM OI_ORG_T008@DBLink_Org<br \/>\nWhere s_c1 not in ( Select cn_s_owner_id from OI_ND_USER )<\/p>\n<p>&#8212; \u5220\u9664\u6570\u636e\u5e93\u8fde\u63a5<br \/>\nDROP DATABASE LINK DBLink_Org;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5c06\u6240\u6709\u4eba\u5458\u90fd\u5f00\u901a\u7f51\u76d8\u529f\u80fd\uff0c\u6570\u636e\u5e93\u9700\u8981\u5728 Oiorg\u4e0a\u8fd0\u884c\uff0c\u7cfb\u7edf\u652f\u6301\u00a0MSSql\u53caOracle\u6570\u636e\u5e93 &#038;#821 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":968,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,2],"tags":[15],"class_list":["post-960","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ercikf","category-pcenter","tag-sql"],"_links":{"self":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/comments?post=960"}],"version-history":[{"count":1,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/960\/revisions"}],"predecessor-version":[{"id":972,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/960\/revisions\/972"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/media\/968"}],"wp:attachment":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/media?parent=960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/categories?post=960"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/tags?post=960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}