【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:22.9.3.1.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
--间隔-范围分区
CREATE TABLE sales_interval_range (prod_id NUMBER(6) NOT NULL, cust_id NUMBER
NOT NULL,time_id DATE NOT NULL, channel_id char(1) NOT NULL,
promo_id NUMBER (6) NOT NULL,quantity_sold NUMBER(3) NOT NULL,
amount_sold NUMBER(10,2) NOT NULL)
PARTITION BY RANGE (time_id)
INTERVAL(NUMTOYMINTERVAL(1, 'month'))
SUBPARTITION BY RANGE (cust_id)
SUBPARTITION TEMPLATE
(
SUBPARTITION sp1 VALUES LESS THAN (50000),
SUBPARTITION sp2 VALUES LESS THAN (100000),
SUBPARTITION sp3 VALUES LESS THAN (150000),
SUBPARTITION sp4 VALUES LESS THAN (MAXVALUE)
)
(
PARTITION p1 VALUES LESS THAN (TO_DATE('1-04-1999','DD-MM-YYYY')),
PARTITION p2 VALUES LESS THAN (TO_DATE('1-07-1999','DD-MM-YYYY')),
PARTITION p3 VALUES LESS THAN (TO_DATE('1-10-1999','DD-MM-YYYY')),
PARTITION p4 VALUES LESS THAN (TO_DATE('1-01-2000','DD-MM-YYYY'))
);