Oracle 间隔分区

-- Create table

create table T_DW_SD_SY_GLOG_ROLELOGIN

(

  logtime  DATE not null,

  platform VARCHAR2(64) not null,

  userid   NUMBER(12) not null

)

partition by range (LOGTIME)

(

  partition P20140131 values less than (TO_DATE(' 2014-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

    tablespace TS_REALTIME_DATA

    pctfree 10

    initrans 1

    maxtrans 255

);

-- Create/Recreate primary, unique and foreign key constraints 

alter table T_DW_SD_SY_GLOG_ROLELOGIN

  add constraint ROLELOGIN primary key (LOGTIME, PLATFORM, USERID)

  using index 

  tablespace TS_REALTIME_DATA

  pctfree 10

  initrans 2

  maxtrans 255;