--创建自动分区表:
--已日期类型分区
CREATE TABLE T_DPI_FIRSTVISIT_HTTP(
DATE_TAG DATE,
STATDATE VARCHAR(8),
ACC_NBR VARCHAR2(20),
CATEGORY VARCHAR2(200),
SUB_DOMAIN VARCHAR2(1000),
TOTAL_FLOW NUMBER(10),
TOTAL_DURATION NUMBER(10)
)
PARTITION BY RANGE(DATE_TAG)
INTERVAL (numtodsinterval(1,'DAY'))
(
PARTITION part_01 values LESS THAN (TO_DATE('20171231','YYYYMMDD'))
);
insert into T_DPI_FIRSTVISIT_HTTP (DATE_TAG,STATDATE,ACC_NBR,CATEGORY,SUB_DOMAIN,TOTAL_FLOW,TOTAL_DURATION)
VALUES (SYSDATE+2,TO_CHAR(SYSDATE,'YYYYMMDD'),'00001','GATEGORY','sub_domain',6,7);
select * from T_DPI_FIRSTVISIT_HTTP
--查询表分区的信息
SELECT * FROM USER_SEGMENTS;
--清空表分区数据:
alter table T_DPI_FIRSTVISIT_HTTP truncate partition part_01;
--直接删除分区:
alter table T_DPI_FIRSTVISIT_HTTP drop partition part_01;