{"id":906,"date":"2012-06-06T23:59:26","date_gmt":"2012-06-06T15:59:26","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=906"},"modified":"2012-06-12T16:39:21","modified_gmt":"2012-06-12T08:39:21","slug":"11g%e6%95%b0%e6%8d%ae%e6%b3%b5network_link%e5%8a%9f%e8%83%bd%e5%a2%9e%e5%bc%ba","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=906","title":{"rendered":"11g\u6570\u636e\u6cf5NETWORK_LINK\u529f\u80fd\u589e\u5f3a"},"content":{"rendered":"<p>11g\u589e\u5f3a\u4e86\u6570\u636e\u6cf5\u7684NETWORK_LINK\u529f\u80fd\uff0c\u4f7f\u5f97\u8fdc\u7aef\u7684\u5bfc\u5165\u6216\u5bfc\u51fa\u4e5f\u652f\u6301\u5206\u533a\u7c92\u5ea6\u3002<br \/>\n\u572810g\u7684\u65f6\u5019\uff0c\u6570\u636e\u6cf5\u7684NETWORK_LINK\u53ea\u652f\u6301\u8868\u7c92\u5ea6\uff1a<\/p>\n<pre lang='SQL'>[orat3@hpserver2 ~]$ expdp test\/test network_link=ora10204 dumpfile=tpart.dp logfile=test.log directory=dd tables=t_part:p1\r\nExport: Release 10.2.0.4.0 - 64bit Production on Monday, 4 June, 2012 0:38:31\r\nCopyright (c) 2003, 2007, Oracle. All rights reserved.\r\nConnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nORA-39001: invalid argument value\r\nORA-39203: Partition selection is not supported over a network link.<\/pre>\n<p>\u5f88\u660e\u663e10g\u5e76\u4e0d\u652f\u6301\u901a\u8fc7\u7f51\u7edc\u65b9\u5f0f\u7684\u5206\u533a\u9009\u62e9\u529f\u80fd\u3002\u800c\u4e14\u5bf9\u4e8e\u5206\u533a\u8868\u800c\u8a00\uff0c\u65e0\u8bba\u662f\u5bfc\u51fa\u8fd8\u662f\u5bfc\u5165\uff0c\u90fd\u662f\u5df2\u4e00\u4e2a\u6574\u4f53\u5b8c\u6210\u7684\u3002<br \/>\n\u800c\u572811g\u4e2d\uff0c\u65e0\u8bba\u662f\u5bfc\u5165\u8fd8\u662f\u5bfc\u51fa\uff0cNETWORK_LINK\u65b9\u5f0f\u90fd\u652f\u6301\u5206\u533a\u7c92\u5ea6\uff1a<\/p>\n<pre lang='SQL'>solaris*orcl-\/home\/oracle$ expdp test\/test network_link=t111g dumpfile=t_part_hash.dp directory=d_output nologfile=y tables=t_part_hash:sys_p61\r\nExport: Release 11.2.0.3.0 - Production on Mon Jun 4 08:24:54 2012\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Oracle Label Security and Real Application Testing options\r\nStarting \"TEST\".\"SYS_EXPORT_TABLE_01\": test\/******** network_link=t111g dumpfile=t_part_hash.dp directory=d_output nologfile=y tables=t_part_hash:sys_p61 \r\nEstimate in progress using BLOCKS method...\r\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE_DATA\r\nTotal estimation using BLOCKS method: 8 MB\r\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE\r\n. . exported \"TEST\".\"T_PART_HASH\":\"SYS_P61\" 5.476 KB 13 rows\r\nMaster table \"TEST\".\"SYS_EXPORT_TABLE_01\" successfully loaded\/unloaded\r\n******************************************************************************\r\nDump file set for TEST.SYS_EXPORT_TABLE_01 is:\r\n\/home\/oracle\/t_part_hash.dp\r\nJob \"TEST\".\"SYS_EXPORT_TABLE_01\" successfully completed at 08:25:57<\/pre>\n<p>\u8fd9\u4e2a\u529f\u80fd\u6ca1\u6709\u5728\u65b0\u7279\u6027\u6587\u6863\u4e2d\u4f53\u73b0\uff0c\u4f46\u662f\u5374\u662f\u4e00\u4e2a\u4e0d\u9519\u7684\u529f\u80fd\u63d0\u5347\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>11g\u589e\u5f3a\u4e86\u6570\u636e\u6cf5\u7684NETWORK_LINK\u529f\u80fd\uff0c\u4f7f\u5f97\u8fdc\u7aef\u7684\u5bfc\u5165\u6216\u5bfc\u51fa\u4e5f\u652f\u6301\u5206\u533a\u7c92\u5ea6\u3002 \u572810g\u7684\u65f6\u5019\uff0c\u6570\u636e\u6cf5\u7684NETWORK_LINK\u53ea\u652f\u6301\u8868\u7c92\u5ea6\uff1a [orat3@hpserver2 ~]$ expdp test\/test network_link=ora10204 dumpfile=tpart.dp logfile=test.log directory=dd tables=t_part:p1 Export: Release 10.2.0.4.0 &#8211; 64bit Production on Monday, 4 June, 2012 0:38:31 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=906\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[341,534,772,654,771,460],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-eC","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/906"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=906"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/906\/revisions"}],"predecessor-version":[{"id":912,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/906\/revisions\/912"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}