-- Create table

create table TEST20181220

(

DATA_ID NUMBER,

BUSI_DT DATE, 

INPUT_DT DATE

)

PARTITION BY RANGE (BUSI_DT) INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))

STORE IN (MDR)

(PARTITION PM_201804 VALUES LESS THAN (TO_DATE('2018-05-01','YYYY-MM-DD')));