【SQL开源代码栏目提醒】:本文主要为网学会员提供22.9.1.1.sql,希望对需要22.9.1.1.sql网友有所帮助,学习一下!
--范围-范围分区
CREATE TABLE sales_range_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)
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)
)
(
PARTITION VALUES LESS THAN (TO_DATE('1-04-1999','DD-MM-YYYY')),
PARTITION VALUES LESS THAN (TO_DATE('1-07-1999','DD-MM-YYYY')),
PARTITION VALUES LESS THAN (TO_DATE('1-10-1999','DD-MM-YYYY')),
PARTITION VALUES LESS THAN (TO_DATE('1-01-2000','DD-MM-YYYY'))
);