Oracle按月分区

create table qywx_send_msg_part
(
  id             NVARCHAR2(32) default sys_guid() not null,
  pinpai         NVARCHAR2(32) not null,
  to_user        NVARCHAR2(32) not null,
  send_content   VARCHAR2(1000) not null,
  has_send       CHAR(1) default 'N',
  request_detail CLOB,
  result_detail  CLOB,
  create_time    DATE default SYSDATE,
  update_time    DATE default SYSDATE
)
PARTITION BY RANGE (create_time)
INTERVAL(numtoyminterval(1,'month'))
( partition p0 values less than (to_date('2000-01-01','yyyy-mm-dd')) )
tablespace OFFICE_DATA;