CREATE TABLE CFMC
(NODEID CHAR(7) NOT NULL,
DEV_NAME VARCHAR2(12),
CHANNEL_ID CHAR(4),
DURING_TIME varchar2(14),
PMEAN NUMBER(7, 3),
OMEAN NUMBER(7, 3))
PARTITION BY RANGE (substr(DURING_TIME,7,2))
(PARTITION CFMC_PART1
VALUES LESS THAN (11)
TABLESPACE PART1_TS,
PARTITION CFMC_PART2
VALUES LESS THAN (21)
TABLESPACE PART2_TS,
PARTITION CFMC_PART3
VALUES LESS THAN (MAXVALUE)
TABLESPACE PART3_TS); 我想只保存最近3个月的数据,请问如何按照时间设计分区呢?
(NODEID CHAR(7) NOT NULL,
DEV_NAME VARCHAR2(12),
CHANNEL_ID CHAR(4),
DURING_TIME varchar2(14),
PMEAN NUMBER(7, 3),
OMEAN NUMBER(7, 3))
PARTITION BY RANGE (substr(DURING_TIME,7,2))
(PARTITION CFMC_PART1
VALUES LESS THAN (11)
TABLESPACE PART1_TS,
PARTITION CFMC_PART2
VALUES LESS THAN (21)
TABLESPACE PART2_TS,
PARTITION CFMC_PART3
VALUES LESS THAN (MAXVALUE)
TABLESPACE PART3_TS); 我想只保存最近3个月的数据,请问如何按照时间设计分区呢?
我的想法是先用时间段做范围划分,用nodeid或者channel_id做散列划分。