在SUBPARTITION中使用INTERVAL(NUMTOYMINTERVAL(1，'MONTH') [英] using INTERVAL (NUMTOYMINTERVAL (1,'MONTH') in SUBPARTITION

问题描述

我正在尝试将分区添加到我创建的表中.我希望它在"PARTITION GRP"上进行分区，然后按月份进行分区.但是我不知道如何在子分区内编写INTERVAL子句. 有人可以帮我吗?谢谢！

I'm trying to add partitions to a table I created. I want it partitioned on "PARTITION GRP" and subpartitioned by month. But I don't know how to write the INTERVAL clause inside a subpartition. Can someone help me on this? thanks!

PARTITION BY RANGE (PARTITION_GRP)
SUBPARTITION BY RANGE (RPTG_MTH_DATE)
INTERVAL(NUMTOYMINTERVAL(1,'MONTH'))
(
   PARTITION PG_0 VALUES LESS THAN (1)
  (SUBPARTITION PG_0_201401 VALUES LESS THAN (TO_DATE('1-FEB-2014', 'DD-MON-YYYY'))),
   PARTITION PG_1 VALUES LESS THAN (2)
  (SUBPARTITION PG_1_201401 VALUES LESS THAN (TO_DATE('1-FEB-2014', 'DD-MON-YYYY'))),   
   PARTITION PG_2 VALUES LESS THAN (3)
  (SUBPARTITION PG_2_201401 VALUES LESS THAN (TO_DATE('1-FEB-2014', 'DD-MON-YYYY'))),
   PARTITION PG_3 VALUES LESS THAN (4)
  (SUBPARTITION PG_3_201401 VALUES LESS THAN (TO_DATE('1-FEB-2014', 'DD-MON-YYYY'))),
   PARTITION PG_4 VALUES LESS THAN (MAXVALUE)
  (SUBPARTITION PG_4_201401 VALUES LESS THAN (TO_DATE('1-FEB-2014', 'DD-MON-YYYY')))
 ) 

推荐答案

来自文档:

间隔分区的限制
INTERVAL子句受以下限制:

Restrictions on Interval Partitioning
The INTERVAL clause is subject to the following restrictions:

• 您只能指定一个分区键列，并且必须为NUMBER或DATE类型.
• 索引组织的表不支持此子句.
• 您不能在间隔分区的表上创建域索引.
• 子分区级别不支持间隔分区. ...

• You can specify only one partitioning key column, and it must be of NUMBER or DATE type.
• This clause is not supported for index-organized tables.
• You cannot create a domain index on an interval-partitioned table.
• Interval partitioning is not supported at the subpartition level. ...

所以您不能进行间隔子分区.

So you can't have interval subpartitioning.

这篇关于在SUBPARTITION中使用INTERVAL(NUMTOYMINTERVAL(1，'MONTH')的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！