Oracle 11g 自动分区例子

-- 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')));