我们可以将分区拆分为多个子分区 [英] Can we split the partition into multiple sub partition

问题描述

根据我们的类，我们已经了解到在将表分区为多个分区后，例如P1，P2，P3和P4等。如果我们想要，可以将P2分成多个分区而不是仅仅两个分区。如果是，那么任何人都可以用一个例子来解释。谢谢。



我的尝试：



我们试过< br $>

According to our classes, we have learned that after partitioning the table into multiple partitions examples P1, P2, P3, and P4 etc. Later if we want to is it possible to split P2 into multiple partitions rather than just two partitions. If yes, then could anyone explain with an example. Thank you.

What I have tried:

We tried

ALTER TABLE SPLIT PARTITION p0 INTO 
  (PARTITION p01 VALUES LESS THAN (25),
   PARTITION p02 VALUES LESS THAN (50), 
   PARTITION p03 VALUES LESS THAN (75),
   PARTITION p04);
ALTER TABLE SPLIT PARTITION p0 INTO 
  (PARTITION p01 VALUES LESS THAN (25),
   PARTITION p02);

****但是收到错误信息****

****BUT GETTING ERROR MESSAGE****

推荐答案

请阅读本文：修改分区功能Microsoft Docs [ ^ ]

这篇关于我们可以将分区拆分为多个子分区的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！