{"id":426,"date":"2019-11-22T16:44:22","date_gmt":"2019-11-22T08:44:22","guid":{"rendered":"http:\/\/www.821121.com\/?p=426"},"modified":"2020-12-11T10:19:01","modified_gmt":"2020-12-11T02:19:01","slug":"12c%e6%96%b0%e7%89%b9%e6%80%a7%ef%bc%9a%e5%a4%9a%e4%b8%aa%e5%88%86%e5%8c%ba%e5%90%88%e5%b9%b6%e4%b8%ba%e4%b8%80%e4%b8%aa%e5%88%86%e5%8c%ba%ef%bc%9b%e4%b8%80%e4%b8%aa%e5%88%86%e5%8c%ba%e6%8b%86","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=426","title":{"rendered":"12C\u65b0\u7279\u6027\uff1a\u591a\u4e2a\u5206\u533a\u5408\u5e76\u4e3a\u4e00\u4e2a\u5206\u533a\uff1b\u4e00\u4e2a\u5206\u533a\u62c6\u5206\u4e3a\u591a\u4e2a\u5206\u533a"},"content":{"rendered":"<h2>1\u3001\u591a\u4e2a\u5206\u533a\u5408\u5e76\u4e3a\u4e00\u4e2a\u5206\u533a<\/h2>\n<pre><code class=\"language-sql\">SQL&gt; ALTER TABLE t_whs_p MERGE\n  2  PARTITIONS p2, p3, p4\n  3  INTO PARTITION p2_4;\n\nTable altered.\nSQL&gt; COL TABLE_NAME FORMAT A15\nSQL&gt; COL PARTITION_NAME FORMAT A15\nSQL&gt; select TABLE_NAME,PARTITION_NAME FROM dba_tab_partitions where TABLE_OWNER=&#039;TEST&#039; AND TABLE_NAME=&#039;T_WHS_P&#039;;\n\nTABLE_NAME      PARTITION_NAME\n--------------- ---------------\nT_WHS_P         P1\nT_WHS_P         P2_4\nT_WHS_P         P5\n\nSQL&gt; <\/code><\/pre>\n<h2>2\u3001\u4e00\u4e2a\u5206\u533a\u62c6\u5206\u4e3a\u591a\u4e2a\u5206\u533a<\/h2>\n<pre><code class=\"language-sql\">SQL&gt; ALTER TABLE t_whs_p SPLIT\n  2  PARTITION p2_4 INTO (\n  3  PARTITION p2 VALUES LESS THAN (20),\n  4  PARTITION p3 VALUES LESS THAN (30),\n  5  PARTITION p4 VALUES LESS THAN (40)\n  6  );\n)\n*\nERROR at line 6:\nORA-14805: last resulting partition cannot contain bounds<\/code><\/pre>\n<p>\u6700\u540e\u4e00\u4e2a\u5206\u533a\u4e0d\u80fd\u5305\u542bLESS THAN\uff0c\u56e0\u4e3a\u9700\u8981\u7ee7\u627f\u539f\u5148\u5206\u533a\u7684LESS THAN<\/p>\n<pre><code class=\"language-sql\">SQL&gt; ALTER TABLE t_whs_p SPLIT\n  2  PARTITION p2_4 INTO (\n  3  PARTITION p2 VALUES LESS THAN (20),\n  4  PARTITION p3 VALUES LESS THAN (30),\n  5  PARTITION p4 \n  6  );\n\nTable altered.\n\nSQL&gt; select TABLE_NAME,PARTITION_NAME FROM dba_tab_partitions where TABLE_OWNER=&#039;TEST&#039; AND TABLE_NAME=&#039;T_WHS_P&#039;;\n\nTABLE_NAME      PARTITION_NAME\n--------------- ---------------\nT_WHS_P         P1\nT_WHS_P         P2\nT_WHS_P         P3\nT_WHS_P         P4\nT_WHS_P         P5<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1\u3001\u591a\u4e2a\u5206\u533a\u5408\u5e76\u4e3a\u4e00\u4e2a\u5206\u533a SQL&gt; ALT<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,39],"tags":[],"class_list":["post-426","post","type-post","status-publish","format-standard","hentry","category-oracle-12c","category-39"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/426","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=426"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/426\/revisions"}],"predecessor-version":[{"id":433,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/426\/revisions\/433"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=426"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}