3,491
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE T_TEST
(
TABLE_ID VARCHAR2(64) NOT NULL,
CREATE_TIME DATE DEFAULT SYSDATE
)
PARTITION BY RANGE (CREATE_TIME)
INTERVAL(NUMTOYMINTERVAL(1, 'MONTH')) STORE IN (TBS_TEST_DATA)
SUBPARTITION BY LIST(CREATE_TIME)
SUBPARTITION TEMPLATE(
SUBPARTITION SP_0 VALUES(NULL) TABLESPACE TBS_TEST_DATA)
(PARTITION P_0 VALUES LESS THAN (TO_DATE('1970-01-01', 'YYYY-MM-DD')) TABLESPACE TBS_TEST_DATA);
INSERT INTO T_TEST (TABLE_ID,CREATE_TIME) VALUES ('test01',NULL);
COMMIT;