Oracle 分区索引

-- Create table
create table TLCB_MON_LINUX
(
  sdate        DATE,
  ip           VARCHAR2(20),
  processcpu   CLOB,
  processmem   CLOB,
  port         CLOB,
  countprocess VARCHAR2(100),
  countport    VARCHAR2(100)
)
partition by range (SDATE)
(
  partition P20170524 values less than (TO_DATE(' 2017-05-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace USERS
    pctfree 10
    initrans 1
    maxtrans 255,


发我和小小 ,


-- Create table
create table ESB2_TRANS_LOG
(
  esbflowno        VARCHAR2(100) not null,
  flowstepid       VARCHAR2(3) not null,
  locationid       VARCHAR2(20) not null,
  channelid        VARCHAR2(40),
  serviceid        VARCHAR2(40),
  respstatus       CHAR(1),
  respcode         VARCHAR2(30),
  respmsg          VARCHAR2(512),
  operstamp        TIMESTAMP(3) default systimestamp not null,
  logicsystem      VARCHAR2(40),
  realsystem       VARCHAR2(40),
  trans_da