CREATE TABLE XIAOYITEST
(
"ID" VARCHAR2(40 BYTE) NOT NULL ,
"WD" VARCHAR2(60 BYTE) NULL ,
"JD" VARCHAR2(60 BYTE) NULL ,
"LRSJ" DATE NULL
)
PARTITION BY RANGE (LRSJ) interval (numtoyMinterval(1,'MONTH'))
(
PARTITION p1 VALUES LESS THAN (TO_DATE('2017-09-01', 'yyyy-mm-dd'))
);