--创建分区表,带默认子分区
--DROP TABLE SA.BUSTB_TESTRESULT;
CREATE table SA.BUSTB_TESTRESULT
(
SUMMAR_ID NUMBER,
ITEM_ID NUMBER,
VALUE VARCHAR2(400),
RESULT VARCHAR2(20),
TESTSTARTTIME TIMESTAMP(6),
PROJECT_ID NUMBER,
FAILMESSAGE VARCHAR2(1000),
ERRORMESSAGE VARCHAR2(1000),
SPENDTIME NUMBER
)
tablespace XDCDATA
PARTITION BY RANGE("TESTSTARTTIME") SUBPARTITION BY LIST ("PROJECT_ID")
(
PARTITION RESULT_PART_201401 VALUES LESS THAN(TIMESTAMP' 2014-02-01 00:00:00')TABLESPACE XDCDATA
(
SUBPARTITION RESULT_PART_201401_0 VALUES (0) TABLESPACE XDCDATA
)
);
--添加分区
ALTER table BUSTB_TESTRESULT ADD PARTITION RESULT_PART_201402 values less than (TIMESTAMP' 2014-03-01 00:00:00')