--创建自动分区表:
--已日期类型分区
CREATETABLET_DPI_FIRSTVISIT_HTTP(
DATE_TAGDATE,
STATDATEVARCHAR(8),
ACC_NBRVARCHAR2(20),
CATEGORYVARCHAR2(200),
SUB_DOMAINVARCHAR2(1000),
TOTAL_FLOWNUMBER(10),
TOTAL_DURATIONNUMBER(10)
)
PARTITIONBYRANGE(DATE_TAG)
INTERVAL(numtodsinterval(1,'DAY'))
(
PARTITIONpart_01valuesLESSTHAN(TO_DATE('20171231','YYYYMMDD'))
);
insertintoT_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*fromT_DPI_FIRSTVISIT_HTTP
--查询表分区的信息
SELECT*FROMUSER_SEGMENTS;
--清空表分区数据：
altertableT_DPI_FIRSTVISIT_HTTPtruncatepartitionpart_01;
--直接删除分区：
altertableT_DPI_FIRSTVISIT_HTTPdroppartitionpart_01;
