{"id":990,"date":"2012-07-07T23:49:20","date_gmt":"2012-07-07T15:49:20","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=990"},"modified":"2012-07-12T09:28:09","modified_gmt":"2012-07-12T01:28:09","slug":"drop-partition%e4%b8%ba%e4%bb%80%e4%b9%88%e4%b8%8d%e8%bf%9b%e5%9b%9e%e6%94%b6%e7%ab%99","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=990","title":{"rendered":"DROP PARTITION\u4e3a\u4ec0\u4e48\u4e0d\u8fdb\u56de\u6536\u7ad9"},"content":{"rendered":"<p>\u524d\u51e0\u5929\u5728\u7ed9\u516c\u53f8\u7684\u5458\u5de5\u8bb2\u4e00\u4e2a\u6848\u4f8b\u7684\u63d0\u5230\u8fd9\u4e2a\u95ee\u9898\u3002<br \/>\n\u5176\u5b9e\u5f53\u65f6\u63d0\u5230\u4e86\u8fd9\u4e2a\u7279\u70b9\uff0cDROP TABLE\u4f1a\u8fdb\u5165\u56de\u6536\u7ad9\uff0c\u4f46\u662fDROP PARTITION\u5e76\u4e0d\u4f1a\uff0c\u56e0\u6b64DROP PARTITION\u4e4b\u540e\uff0c\u6570\u636e\u65e0\u6cd5\u7b80\u5355\u7684\u56de\u590d\uff0c\u53ea\u80fd\u901a\u8fc7\u903b\u8f91\u6216\u7269\u7406\u5907\u4efd\u7684\u65b9\u5f0f\u6765\u8fdb\u884c\u6570\u636e\u7684\u56de\u590d\u3002<\/p>\n<pre lang='SQL'>SQL> create table t_drop (id number);\r\nTable created.\r\nSQL> drop table t_drop;\r\nTable dropped.\r\nSQL> select object_name, original_name from recyclebin;\r\nOBJECT_NAME ORIGINAL_NAME\r\n------------------------------ --------------------------------\r\nBIN$xJhZqpmfWZXgRDzZK0pZWw==$0 T_DROP\r\nSQL> create table t_part_drop (id number) partition by range (id) \r\n2 (partition p1 values less than (10), \r\n3 partition p2 values less than (20), \r\n4 partition p3 values less than (30), \r\n5 partition pmax values less than (maxvalue));\r\nTable created.\r\nSQL> insert into t_part_drop select rownum from user_objects;\r\n176 rows created.\r\nSQL> commit;\r\nCommit complete.\r\nSQL> alter table t_part_drop drop partition p1;\r\nTable altered.\r\nSQL> select object_name, original_name from recyclebin;\r\nOBJECT_NAME ORIGINAL_NAME\r\n------------------------------ --------------------------------\r\nBIN$xJhZqpmfWZXgRDzZK0pZWw==$0 T_DROP<\/pre>\n<p>\u672c\u6765\u53ea\u662f\u666e\u53ca\u4e00\u4e0b\u8fd9\u4e2a\u5e38\u8bc6\uff0c\u4e0d\u8fc7\u6709\u4eba\u95ee\u6211Oracle\u4e3a\u4ec0\u4e48\u6ca1\u6709\u5b9e\u73b0\u5c06\u5220\u9664\u5206\u533a\u653e\u5728\u56de\u6536\u7ad9\u4e2d\u3002\u8fd9\u4e2a\u95ee\u9898\u95ee\u7684\u5f88\u597d\uff0c\u56e0\u4e3a\u5982\u679c\u8fd9\u4e2a\u529f\u80fd\u5f88\u5bb9\u6613\u5b9e\u73b0\uff0c\u90a3\u4e48Oracle\u80af\u5b9a\u65e9\u5c31\u5b9e\u73b0\u4e86\uff0c\u800c\u5230\u4e8611.2\u4e2dOracle\u4ecd\u7136\u6ca1\u6709\u5b9e\u73b0\u8fd9\u4e2a\u529f\u80fd\uff0c\u90a3\u4e48\u4e00\u5b9a\u8bf4\u660e\u8fd9\u4e2a\u529f\u80fd\u4e0d\u662f\u65e0\u6cd5\u5b9e\u73b0\uff0c\u5c31\u662f\u5b9e\u73b0\u7684\u56f0\u96be\u592a\u5927\u3002<br \/>\n\u56de\u6536\u7ad9\u7684\u5b9e\u73b0\u5e76\u4e0d\u590d\u6742\uff0c\u5f53\u4e00\u5f20\u8868\u88ab\u5220\u9664\u7684\u65f6\u5019\uff0cOracle\u6ca1\u6709\u76f4\u63a5\u91ca\u653e\u8868\u5728\u8868\u7a7a\u95f4\u4e0a\u7684\u7a7a\u95f4\u5360\u7528\uff0c\u800c\u662f\u5c06\u8868\u7b80\u5355\u7684\u6253\u4e86\u4e2a\u6807\u8bc6\uff0c\u8fd9\u6837\u5728\u6b63\u5e38\u67e5\u8be2\u6570\u636e\u5b57\u5178\u65f6\u5c31\u4e0d\u4f1a\u770b\u5230\u8fd9\u5f20\u88ab\u5220\u9664\u7684\u8868\uff0c\u800c\u5982\u679c\u9700\u8981\u6062\u590d\u8fd9\u5f20\u8868\u65f6\uff0c\u53ea\u9700\u8981\u5c06\u6807\u8bc6\u4f4d\u6539\u56de\u6765\u65e2\u53ef\u3002<br \/>\n\u90a3\u4e48\u540c\u6837\u662f\u4fee\u6539\u6570\u636e\u5b57\u5178\uff0c\u4e3a\u4ec0\u4e48\u4e0d\u80fd\u5c06\u88ab\u5220\u9664\u7684\u5206\u533a\u901a\u8fc7\u6807\u8bc6\u7684\u65b9\u6cd5\u653e\u5230\u56de\u6536\u7ad9\u4e2d\u5462\uff0c\u8fd9\u662f\u56e0\u4e3a\uff0c\u5bf9\u4e8e\u8868\u800c\u8a00\uff0c\u5220\u9664\u64cd\u4f5c\u662f\u5c06\u4e00\u4e2a\u6574\u7406\u5b8c\u5168\u5220\u9664\u3002\u800c\u5bf9\u4e8e\u5206\u533a\u7684\u5220\u9664\uff0c\u662f\u5220\u9664\u6574\u4f53\u4e2d\u7684\u4e00\u4e2a\u90e8\u5206\u3002\u5bf9\u4e8e\u5220\u9664\u8fd9\u4e2a\u52a8\u4f5c\u5176\u5b9e\u5e76\u6ca1\u6709\u592a\u5927\u7684\u5f71\u54cd\uff0c\u4f46\u662f\u56de\u6536\u7ad9\u7684\u529f\u80fd\u4e0d\u662f\u4e3a\u4e86\u5220\u9664\uff0c\u800c\u662f\u4e3a\u4e86\u53ef\u4ee5\u5feb\u901f\u7684\u6062\u590d\u3002\u5bf9\u8868\u800c\u8a00\uff0c\u76f4\u63a5\u6062\u590d\u6574\u4f53\u4e0d\u5b58\u5728\u4efb\u4f55\u7684\u95ee\u9898\uff0c\u5373\u4f7f\u540c\u540d\u5bf9\u8c61\u5b58\u5728\uff0c\u4e5f\u53ea\u9700\u6539\u4e2a\u540d\u5b57\u65e2\u53ef\u3002\u800c\u5bf9\u4e8e\u5220\u9664\u5206\u533a\u7684\u6062\u590d\u800c\u8a00\uff0c\u95ee\u9898\u5c31\u4e0d\u90a3\u4e48\u7b80\u5355\u4e86\u3002\u7531\u4e8e\u5206\u533a\u8868\u5e76\u6ca1\u6709\u5220\u9664\uff0c\u56e0\u6b64\u8fd9\u4e2a\u8868\u4ecd\u7136\u53ef\u4ee5\u7ee7\u7eed\u8fdb\u884c\u64cd\u4f5c\uff0c\u867d\u7136\u67d0\u4e2a\u5206\u533a\u88ab\u5220\u9664\u4e86\uff0c\u4f46\u662f\u9664\u975e\u662f\u8303\u56f4\u5206\u533a\u4e2d\u7684MAXVALUE\u5206\u533a\u548c\u5217\u8868\u5206\u533a\u4e2d\u7684DEFAULT\u5206\u533a\uff0c\u5426\u5219\u518d\u63d2\u5165\u539f\u5206\u533a\u5bf9\u5e94\u7684\u6570\u636e\u65f6\uff0c\u5e76\u4e0d\u4f1a\u62a5\u9519\uff0c\u800c\u662f\u4f1a\u63d2\u5165\u5230\u5176\u4ed6\u5206\u533a\u4e2d\uff1a<\/p>\n<pre lang='SQL'>SQL> select * from t_part_drop partition (p2);\r\n        ID\r\n----------\r\n        10\r\n        11\r\n        12\r\n        13\r\n        14\r\n        15\r\n        16\r\n        17\r\n        18\r\n        19\r\n10 rows selected.\r\nSQL> insert into t_part_drop values (5);\r\n1 row created.\r\nSQL> select * from t_part_drop partition (p2);\r\n        ID\r\n----------\r\n        10\r\n        11\r\n        12\r\n        13\r\n        14\r\n        15\r\n        16\r\n        17\r\n        18\r\n        19\r\n         5\r\n11 rows selected.<\/pre>\n<p>\u539f\u8868\u5e94\u8be5\u63d2\u5165\u5206\u533aP1\u7684\u6570\u636e\uff0c\u7531\u4e8e\u5206\u533aP1\u88ab\u5220\u9664\uff0c\u56e0\u6b64\u73b0\u5728\u6ee1\u8db3\u5206\u533aP2\u7684\u6761\u4ef6\uff0c\u88ab\u63d2\u5165\u5230\u5206\u533aP2\u4e2d\uff0c\u8003\u8651\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u5982\u679c\u76f4\u63a5\u6062\u590dP1\u5206\u533a\u4f1a\u600e\u6837\u3002<br \/>\n\u663e\u7136\u8fd9\u4e0d\u662f\u4e00\u4e2a\u7b80\u5355\u7684\u6570\u636e\u5b57\u5178\u7684\u4fee\u6539\u5c31\u80fd\u89e3\u51b3\u7684\u95ee\u9898\uff0c\u4e0d\u4f46\u6d89\u53ca\u5230\u5206\u533a\u6570\u636e\u6539\u53d8\u7684\u95ee\u9898\uff0c\u8fd8\u5fc5\u7136\u4f1a\u5e26\u6765\u5168\u5c40\u548c\u672c\u5730\u7d22\u5f15\u5931\u6548\u7684\u95ee\u9898\uff0c\u66f4\u91cd\u8981\u7684\u662f\uff0c\u53ef\u80fd\u5e26\u6765\u4e3b\u952e\u51b2\u7a81\u7684\u60c5\u51b5\u3002<br \/>\n\u8fd9\u8fd8\u53ea\u662f\u5206\u533a\u8868\u8fdb\u884c\u4e86DML\u7684\u60c5\u51b5\uff0c\u5982\u679c\u5220\u9664\u5206\u533a\u540e\uff0c\u5206\u533a\u8868\u53c8\u8fdb\u884c\u4e86DDL\uff0c\u6bd4\u5982\u65b0SPLIT\u4e86P1\u5206\u533a\uff0c\u90a3\u4e48\u5220\u9664\u5206\u533a\u7684\u6062\u590d\u64cd\u4f5c\u5c31\u66f4\u65e0\u6cd5\u8fdb\u884c\u4e86\u3002<br \/>\n\u5982\u679c\u4e00\u4e2a\u529f\u80fd\u89c9\u5f97\u5f88\u7b80\u5355\u5c31\u53ef\u4ee5\u5b9e\u73b0\uff0c\u4f46\u662fOracle\u5374\u4e00\u76f4\u6ca1\u6709\u5b9e\u73b0\uff0c\u90a3\u4e48\u5f88\u53ef\u80fd\u5b9e\u73b0\u8fd9\u4e2a\u529f\u80fd\u5e76\u4e0d\u50cf\u60f3\u8c61\u7684\u90a3\u4e48\u7b80\u5355\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u524d\u51e0\u5929\u5728\u7ed9\u516c\u53f8\u7684\u5458\u5de5\u8bb2\u4e00\u4e2a\u6848\u4f8b\u7684\u63d0\u5230\u8fd9\u4e2a\u95ee\u9898\u3002 \u5176\u5b9e\u5f53\u65f6\u63d0\u5230\u4e86\u8fd9\u4e2a\u7279\u70b9\uff0cDROP TABLE\u4f1a\u8fdb\u5165\u56de\u6536\u7ad9\uff0c\u4f46\u662fDROP PARTITION\u5e76\u4e0d\u4f1a\uff0c\u56e0\u6b64DROP PARTITION\u4e4b\u540e\uff0c\u6570\u636e\u65e0\u6cd5\u7b80\u5355\u7684\u56de\u590d\uff0c\u53ea\u80fd\u901a\u8fc7\u903b\u8f91\u6216\u7269\u7406\u5907\u4efd\u7684\u65b9\u5f0f\u6765\u8fdb\u884c\u6570\u636e\u7684\u56de\u590d\u3002 SQL> create table t_drop (id number); Table created. SQL> drop table t_drop; Table dropped. SQL> select object_name, original_name from recyclebin; OBJECT_NAME ORIGINAL_NAME &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; BIN$xJhZqpmfWZXgRDzZK0pZWw==$0 T_DROP SQL> create table t_part_drop (id number) partition by range &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=990\">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":[39,851,460,484,485],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-fY","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/990"}],"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=990"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/990\/revisions"}],"predecessor-version":[{"id":991,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/990\/revisions\/991"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=990"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=990"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=990"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}