--创建自动分区表:
@H_502_1@
--已日期类型分区
@H_502_1@
@H_502_1@
@H_502_1@
CREATETABLET_DPI_FIRSTVISIT_HTTP(
@H_502_1@
DATE_TAGDATE,@H_502_1@
STATDATEVARCHAR(8),@H_502_1@
ACC_NBRVARCHAR2(20),@H_502_1@
CATEGORYVARCHAR2(200),@H_502_1@
SUB_DOMAINVARCHAR2(1000),@H_502_1@
TOTAL_FLOWNUMBER(10),@H_502_1@
TOTAL_DURATIONNUMBER(10)
@H_502_1@
)
@H_502_1@
PARTITIONBYRANGE(DATE_TAG)
@H_502_1@
INTERVAL(numtodsinterval(1,'DAY'))
@H_502_1@
(
@H_502_1@
PARTITIONpart_01valuesLESSTHAN(TO_DATE('20171231','YYYYMMDD'))
@H_502_1@
);
@H_502_1@
@H_502_1@
@H_502_1@
@H_502_1@
@H_502_1@
@H_502_1@
@H_502_1@
insertintoT_DPI_FIRSTVISIT_HTTP(DATE_TAG,STATDATE,ACC_NBR,CATEGORY,SUB_DOMAIN,TOTAL_FLOW,TOTAL_DURATION)
@H_502_1@
VALUES(SYSDATE+2,TO_CHAR(SYSDATE,'YYYYMMDD'),'00001','GATEGORY','sub_domain',6,7);
@H_502_1@
@H_502_1@
@H_502_1@