按日期的分区表

-- Create table
create table V_MEMBER_FUNDS_STAT_CLIENT
(
  cleardate                    DATE,
  memberno                     VARCHAR2(20),
  membername                   VARCHAR2(500),
  begincapital                 NUMBER(15,2),
  fundio                       NUMBER(15,2),
  memberfee                    NUMBER,
  mktfee                       NUMBER,
  customerfee                  NUMBER,
  memberclosepl                NUMBER(15,2),
  memberholdpl                 NUMBER(15,2),
  customerdelayfee             NUMBER,
  smemberdelayfee              NUMBER,
  delayfeesum                  NUMBER,
  endcapital                   NUMBER(15,2),
  status                       CHAR(1),
  risk                         NUMBER,
  get_customer_storage_fee     NUMBER(15,2),
  give_sm_storage_fee          NUMBER(15,2),
  member_retention_storage_fee NUMBER(15,2)
)
partition by range (CLEARDATE)
(
  partition V_MEMBER_TRADE_FUNDS_STAT_P1 values less than (TO_DATE(' 2011-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace USERS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 64K
      next 1M
      minextents 1
      maxextents unlimited
    ),
  partition SYS_P707 values less than (TO_DATE(' 2013-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace USERS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 64K
      next 1M
      minextents 1
      maxextents unlimited
    ),
  partition SYS_P705 values less than (TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace USERS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 64K
      next 1M
      minextents 1
      maxextents unlimited
    ),
  partition SYS_P706 values less than (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace USERS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 64K
      next 1M
      minextents 1
      maxextents unlimited
    )
);