ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > record过车数据表 表结构

record过车数据表 表结构

原创 Oracle 作者：wg0411 时间：2017-04-27 10:11:27 0 删除 编辑
下面是工作中使用的主表的表结构，分享出来希望对大家有帮助，尤其是分区的部分。

------------------------------------------------------
-- Export file for user MDCSCENTER                  --
-- Created by Administrator on 2016-12-16, 10:43:12 --
------------------------------------------------------


spool record.log


prompt
prompt Creating table RECORD
prompt =====================
prompt
create table MDCSCENTER.RECORD
(
  ID         VARCHAR2(15) not null,
  TGSJ       DATE not null,
  HPHM       VARCHAR2(15),
  CS         NUMBER,
  CC         NUMBER,
  HPYS       VARCHAR2(4),
  CDBH       VARCHAR2(4),
  DKDM       VARCHAR2(12) not null,
  TPURL      VARCHAR2(300),
  WFXW       NUMBER(6),
  XS         NUMBER,
  XSFX       VARCHAR2(4),
  HPSL       VARCHAR2(1),
  HPJG       VARCHAR2(1),
  CSYS       VARCHAR2(4),
  CDLX       VARCHAR2(1),
  CB         VARCHAR2(2),
  XRYZYS     NUMBER,
  CSYSSX     VARCHAR2(1),
  SBZT       VARCHAR2(1),
  SBSJ       NUMBER,
  LX         VARCHAR2(4),
  SBBH       VARCHAR2(16),
  SJZT       VARCHAR2(1) default '0' not null,
  SLSJ       DATE,
  SHSJ       DATE,
  SHR        VARCHAR2(30),
  STARTDATE  DATE,
  ENDDATE    DATE,
  DATENUMBER VARCHAR2(30),
  GXSJ       DATE,
  TPSL       NUMBER,
  TPURL1     VARCHAR2(300)
)
partition by range (TGSJ)
(
  partition P201306 values less than (TO_DATE(' 2013-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201307 values less than (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201308 values less than (TO_DATE(' 2013-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201309 values less than (TO_DATE(' 2013-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201310 values less than (TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201311 values less than (TO_DATE(' 2013-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201312 values less than (TO_DATE(' 2013-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201401 values less than (TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201402 values less than (TO_DATE(' 2014-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201403 values less than (TO_DATE(' 2014-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201404 values less than (TO_DATE(' 2014-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201405 values less than (TO_DATE(' 2014-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201406 values less than (TO_DATE(' 2014-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201407 values less than (TO_DATE(' 2014-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201408 values less than (TO_DATE(' 2014-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201409 values less than (TO_DATE(' 2014-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201410 values less than (TO_DATE(' 2014-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201411 values less than (TO_DATE(' 2014-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201412 values less than (TO_DATE(' 2014-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201501 values less than (TO_DATE(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201502 values less than (TO_DATE(' 2015-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201503 values less than (TO_DATE(' 2015-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P201504 values less than (TO_DATE(' 2015-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150404 values less than (TO_DATE(' 2015-04-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150407 values less than (TO_DATE(' 2015-04-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150410 values less than (TO_DATE(' 2015-04-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150413 values less than (TO_DATE(' 2015-04-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150416 values less than (TO_DATE(' 2015-04-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150419 values less than (TO_DATE(' 2015-04-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150422 values less than (TO_DATE(' 2015-04-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150425 values less than (TO_DATE(' 2015-04-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150428 values less than (TO_DATE(' 2015-04-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150501 values less than (TO_DATE(' 2015-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150504 values less than (TO_DATE(' 2015-05-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150507 values less than (TO_DATE(' 2015-05-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150510 values less than (TO_DATE(' 2015-05-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150513 values less than (TO_DATE(' 2015-05-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150516 values less than (TO_DATE(' 2015-05-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150519 values less than (TO_DATE(' 2015-05-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150522 values less than (TO_DATE(' 2015-05-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150525 values less than (TO_DATE(' 2015-05-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150528 values less than (TO_DATE(' 2015-05-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150531 values less than (TO_DATE(' 2015-05-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150603 values less than (TO_DATE(' 2015-06-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150606 values less than (TO_DATE(' 2015-06-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150609 values less than (TO_DATE(' 2015-06-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150612 values less than (TO_DATE(' 2015-06-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150615 values less than (TO_DATE(' 2015-06-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150618 values less than (TO_DATE(' 2015-06-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150621 values less than (TO_DATE(' 2015-06-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150624 values less than (TO_DATE(' 2015-06-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150627 values less than (TO_DATE(' 2015-06-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150630 values less than (TO_DATE(' 2015-06-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150703 values less than (TO_DATE(' 2015-07-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150706 values less than (TO_DATE(' 2015-07-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150709 values less than (TO_DATE(' 2015-07-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150712 values less than (TO_DATE(' 2015-07-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150715 values less than (TO_DATE(' 2015-07-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150718 values less than (TO_DATE(' 2015-07-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150721 values less than (TO_DATE(' 2015-07-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150724 values less than (TO_DATE(' 2015-07-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150727 values less than (TO_DATE(' 2015-07-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150730 values less than (TO_DATE(' 2015-07-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150802 values less than (TO_DATE(' 2015-08-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150805 values less than (TO_DATE(' 2015-08-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150808 values less than (TO_DATE(' 2015-08-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150811 values less than (TO_DATE(' 2015-08-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150814 values less than (TO_DATE(' 2015-08-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150817 values less than (TO_DATE(' 2015-08-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150820 values less than (TO_DATE(' 2015-08-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150823 values less than (TO_DATE(' 2015-08-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150826 values less than (TO_DATE(' 2015-08-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150829 values less than (TO_DATE(' 2015-08-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150901 values less than (TO_DATE(' 2015-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150904 values less than (TO_DATE(' 2015-09-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150907 values less than (TO_DATE(' 2015-09-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150910 values less than (TO_DATE(' 2015-09-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150913 values less than (TO_DATE(' 2015-09-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150916 values less than (TO_DATE(' 2015-09-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150919 values less than (TO_DATE(' 2015-09-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150922 values less than (TO_DATE(' 2015-09-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150925 values less than (TO_DATE(' 2015-09-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20150928 values less than (TO_DATE(' 2015-09-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151001 values less than (TO_DATE(' 2015-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151004 values less than (TO_DATE(' 2015-10-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151007 values less than (TO_DATE(' 2015-10-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151010 values less than (TO_DATE(' 2015-10-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151013 values less than (TO_DATE(' 2015-10-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151016 values less than (TO_DATE(' 2015-10-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151019 values less than (TO_DATE(' 2015-10-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151022 values less than (TO_DATE(' 2015-10-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151025 values less than (TO_DATE(' 2015-10-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151028 values less than (TO_DATE(' 2015-10-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151031 values less than (TO_DATE(' 2015-10-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151103 values less than (TO_DATE(' 2015-11-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151106 values less than (TO_DATE(' 2015-11-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151109 values less than (TO_DATE(' 2015-11-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151112 values less than (TO_DATE(' 2015-11-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151115 values less than (TO_DATE(' 2015-11-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151118 values less than (TO_DATE(' 2015-11-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151121 values less than (TO_DATE(' 2015-11-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151124 values less than (TO_DATE(' 2015-11-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151127 values less than (TO_DATE(' 2015-11-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151130 values less than (TO_DATE(' 2015-11-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151203 values less than (TO_DATE(' 2015-12-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151206 values less than (TO_DATE(' 2015-12-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151209 values less than (TO_DATE(' 2015-12-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151212 values less than (TO_DATE(' 2015-12-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151215 values less than (TO_DATE(' 2015-12-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151218 values less than (TO_DATE(' 2015-12-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151221 values less than (TO_DATE(' 2015-12-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151224 values less than (TO_DATE(' 2015-12-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151227 values less than (TO_DATE(' 2015-12-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20151230 values less than (TO_DATE(' 2015-12-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160102 values less than (TO_DATE(' 2016-01-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160105 values less than (TO_DATE(' 2016-01-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160108 values less than (TO_DATE(' 2016-01-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160111 values less than (TO_DATE(' 2016-01-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160114 values less than (TO_DATE(' 2016-01-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160117 values less than (TO_DATE(' 2016-01-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160120 values less than (TO_DATE(' 2016-01-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160123 values less than (TO_DATE(' 2016-01-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160126 values less than (TO_DATE(' 2016-01-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160129 values less than (TO_DATE(' 2016-01-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160201 values less than (TO_DATE(' 2016-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160204 values less than (TO_DATE(' 2016-02-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160207 values less than (TO_DATE(' 2016-02-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160210 values less than (TO_DATE(' 2016-02-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160213 values less than (TO_DATE(' 2016-02-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160216 values less than (TO_DATE(' 2016-02-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160219 values less than (TO_DATE(' 2016-02-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160222 values less than (TO_DATE(' 2016-02-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160225 values less than (TO_DATE(' 2016-02-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160228 values less than (TO_DATE(' 2016-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160302 values less than (TO_DATE(' 2016-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160305 values less than (TO_DATE(' 2016-03-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160308 values less than (TO_DATE(' 2016-03-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160311 values less than (TO_DATE(' 2016-03-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160314 values less than (TO_DATE(' 2016-03-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160317 values less than (TO_DATE(' 2016-03-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160320 values less than (TO_DATE(' 2016-03-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160323 values less than (TO_DATE(' 2016-03-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160326 values less than (TO_DATE(' 2016-03-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160329 values less than (TO_DATE(' 2016-03-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160401 values less than (TO_DATE(' 2016-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160404 values less than (TO_DATE(' 2016-04-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160407 values less than (TO_DATE(' 2016-04-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160410 values less than (TO_DATE(' 2016-04-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160413 values less than (TO_DATE(' 2016-04-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160416 values less than (TO_DATE(' 2016-04-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160419 values less than (TO_DATE(' 2016-04-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160422 values less than (TO_DATE(' 2016-04-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160425 values less than (TO_DATE(' 2016-04-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160428 values less than (TO_DATE(' 2016-04-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160501 values less than (TO_DATE(' 2016-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160504 values less than (TO_DATE(' 2016-05-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160507 values less than (TO_DATE(' 2016-05-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160510 values less than (TO_DATE(' 2016-05-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160513 values less than (TO_DATE(' 2016-05-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160516 values less than (TO_DATE(' 2016-05-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160519 values less than (TO_DATE(' 2016-05-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160522 values less than (TO_DATE(' 2016-05-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160525 values less than (TO_DATE(' 2016-05-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160528 values less than (TO_DATE(' 2016-05-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160531 values less than (TO_DATE(' 2016-05-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160603 values less than (TO_DATE(' 2016-06-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160606 values less than (TO_DATE(' 2016-06-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160609 values less than (TO_DATE(' 2016-06-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160612 values less than (TO_DATE(' 2016-06-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160615 values less than (TO_DATE(' 2016-06-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160618 values less than (TO_DATE(' 2016-06-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160621 values less than (TO_DATE(' 2016-06-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160624 values less than (TO_DATE(' 2016-06-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160627 values less than (TO_DATE(' 2016-06-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160630 values less than (TO_DATE(' 2016-06-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160703 values less than (TO_DATE(' 2016-07-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160706 values less than (TO_DATE(' 2016-07-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160709 values less than (TO_DATE(' 2016-07-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160712 values less than (TO_DATE(' 2016-07-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160715 values less than (TO_DATE(' 2016-07-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160718 values less than (TO_DATE(' 2016-07-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160721 values less than (TO_DATE(' 2016-07-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160724 values less than (TO_DATE(' 2016-07-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160727 values less than (TO_DATE(' 2016-07-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160730 values less than (TO_DATE(' 2016-07-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160802 values less than (TO_DATE(' 2016-08-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160805 values less than (TO_DATE(' 2016-08-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160808 values less than (TO_DATE(' 2016-08-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160811 values less than (TO_DATE(' 2016-08-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160814 values less than (TO_DATE(' 2016-08-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160817 values less than (TO_DATE(' 2016-08-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160820 values less than (TO_DATE(' 2016-08-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160823 values less than (TO_DATE(' 2016-08-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160826 values less than (TO_DATE(' 2016-08-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160829 values less than (TO_DATE(' 2016-08-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160901 values less than (TO_DATE(' 2016-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160904 values less than (TO_DATE(' 2016-09-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160907 values less than (TO_DATE(' 2016-09-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160910 values less than (TO_DATE(' 2016-09-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160913 values less than (TO_DATE(' 2016-09-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160916 values less than (TO_DATE(' 2016-09-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160919 values less than (TO_DATE(' 2016-09-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160922 values less than (TO_DATE(' 2016-09-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160925 values less than (TO_DATE(' 2016-09-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20160928 values less than (TO_DATE(' 2016-09-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161001 values less than (TO_DATE(' 2016-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161004 values less than (TO_DATE(' 2016-10-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161007 values less than (TO_DATE(' 2016-10-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161010 values less than (TO_DATE(' 2016-10-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161013 values less than (TO_DATE(' 2016-10-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161016 values less than (TO_DATE(' 2016-10-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161019 values less than (TO_DATE(' 2016-10-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161022 values less than (TO_DATE(' 2016-10-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161025 values less than (TO_DATE(' 2016-10-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161028 values less than (TO_DATE(' 2016-10-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161031 values less than (TO_DATE(' 2016-10-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161103 values less than (TO_DATE(' 2016-11-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161106 values less than (TO_DATE(' 2016-11-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161109 values less than (TO_DATE(' 2016-11-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161112 values less than (TO_DATE(' 2016-11-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161115 values less than (TO_DATE(' 2016-11-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161118 values less than (TO_DATE(' 2016-11-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161121 values less than (TO_DATE(' 2016-11-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161124 values less than (TO_DATE(' 2016-11-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161127 values less than (TO_DATE(' 2016-11-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161130 values less than (TO_DATE(' 2016-11-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161203 values less than (TO_DATE(' 2016-12-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_DATA,
  partition P20161204 values less than (TO_DATE(' 2016-12-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161205 values less than (TO_DATE(' 2016-12-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161206 values less than (TO_DATE(' 2016-12-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161207 values less than (TO_DATE(' 2016-12-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161208 values less than (TO_DATE(' 2016-12-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161209 values less than (TO_DATE(' 2016-12-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161210 values less than (TO_DATE(' 2016-12-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161211 values less than (TO_DATE(' 2016-12-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161212 values less than (TO_DATE(' 2016-12-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161213 values less than (TO_DATE(' 2016-12-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161214 values less than (TO_DATE(' 2016-12-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161215 values less than (TO_DATE(' 2016-12-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161216 values less than (TO_DATE(' 2016-12-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161217 values less than (TO_DATE(' 2016-12-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161218 values less than (TO_DATE(' 2016-12-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161219 values less than (TO_DATE(' 2016-12-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161220 values less than (TO_DATE(' 2016-12-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161221 values less than (TO_DATE(' 2016-12-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161222 values less than (TO_DATE(' 2016-12-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161223 values less than (TO_DATE(' 2016-12-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161224 values less than (TO_DATE(' 2016-12-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161225 values less than (TO_DATE(' 2016-12-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161226 values less than (TO_DATE(' 2016-12-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161227 values less than (TO_DATE(' 2016-12-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161228 values less than (TO_DATE(' 2016-12-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161229 values less than (TO_DATE(' 2016-12-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161230 values less than (TO_DATE(' 2016-12-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20161231 values less than (TO_DATE(' 2017-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170101 values less than (TO_DATE(' 2017-01-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170102 values less than (TO_DATE(' 2017-01-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170103 values less than (TO_DATE(' 2017-01-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170104 values less than (TO_DATE(' 2017-01-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170105 values less than (TO_DATE(' 2017-01-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170106 values less than (TO_DATE(' 2017-01-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170107 values less than (TO_DATE(' 2017-01-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170108 values less than (TO_DATE(' 2017-01-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170109 values less than (TO_DATE(' 2017-01-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170110 values less than (TO_DATE(' 2017-01-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170111 values less than (TO_DATE(' 2017-01-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170112 values less than (TO_DATE(' 2017-01-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170113 values less than (TO_DATE(' 2017-01-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170114 values less than (TO_DATE(' 2017-01-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170115 values less than (TO_DATE(' 2017-01-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170116 values less than (TO_DATE(' 2017-01-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170117 values less than (TO_DATE(' 2017-01-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170118 values less than (TO_DATE(' 2017-01-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170119 values less than (TO_DATE(' 2017-01-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170120 values less than (TO_DATE(' 2017-01-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170121 values less than (TO_DATE(' 2017-01-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170122 values less than (TO_DATE(' 2017-01-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170123 values less than (TO_DATE(' 2017-01-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170124 values less than (TO_DATE(' 2017-01-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170125 values less than (TO_DATE(' 2017-01-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170126 values less than (TO_DATE(' 2017-01-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170127 values less than (TO_DATE(' 2017-01-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170128 values less than (TO_DATE(' 2017-01-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170129 values less than (TO_DATE(' 2017-01-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170130 values less than (TO_DATE(' 2017-01-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170131 values less than (TO_DATE(' 2017-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170201 values less than (TO_DATE(' 2017-02-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170202 values less than (TO_DATE(' 2017-02-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170203 values less than (TO_DATE(' 2017-02-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170204 values less than (TO_DATE(' 2017-02-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170205 values less than (TO_DATE(' 2017-02-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170206 values less than (TO_DATE(' 2017-02-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170207 values less than (TO_DATE(' 2017-02-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170208 values less than (TO_DATE(' 2017-02-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170209 values less than (TO_DATE(' 2017-02-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170210 values less than (TO_DATE(' 2017-02-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170211 values less than (TO_DATE(' 2017-02-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170212 values less than (TO_DATE(' 2017-02-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170213 values less than (TO_DATE(' 2017-02-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170214 values less than (TO_DATE(' 2017-02-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170215 values less than (TO_DATE(' 2017-02-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170216 values less than (TO_DATE(' 2017-02-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170217 values less than (TO_DATE(' 2017-02-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170218 values less than (TO_DATE(' 2017-02-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170219 values less than (TO_DATE(' 2017-02-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170220 values less than (TO_DATE(' 2017-02-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170221 values less than (TO_DATE(' 2017-02-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170222 values less than (TO_DATE(' 2017-02-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170223 values less than (TO_DATE(' 2017-02-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170224 values less than (TO_DATE(' 2017-02-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170225 values less than (TO_DATE(' 2017-02-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170226 values less than (TO_DATE(' 2017-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170227 values less than (TO_DATE(' 2017-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170228 values less than (TO_DATE(' 2017-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170301 values less than (TO_DATE(' 2017-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170302 values less than (TO_DATE(' 2017-03-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170303 values less than (TO_DATE(' 2017-03-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170304 values less than (TO_DATE(' 2017-03-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170305 values less than (TO_DATE(' 2017-03-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170306 values less than (TO_DATE(' 2017-03-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170307 values less than (TO_DATE(' 2017-03-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170308 values less than (TO_DATE(' 2017-03-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170309 values less than (TO_DATE(' 2017-03-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170310 values less than (TO_DATE(' 2017-03-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170311 values less than (TO_DATE(' 2017-03-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170312 values less than (TO_DATE(' 2017-03-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170313 values less than (TO_DATE(' 2017-03-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170314 values less than (TO_DATE(' 2017-03-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170315 values less than (TO_DATE(' 2017-03-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170316 values less than (TO_DATE(' 2017-03-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170317 values less than (TO_DATE(' 2017-03-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170318 values less than (TO_DATE(' 2017-03-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170319 values less than (TO_DATE(' 2017-03-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170320 values less than (TO_DATE(' 2017-03-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170321 values less than (TO_DATE(' 2017-03-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170322 values less than (TO_DATE(' 2017-03-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170323 values less than (TO_DATE(' 2017-03-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170324 values less than (TO_DATE(' 2017-03-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170325 values less than (TO_DATE(' 2017-03-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170326 values less than (TO_DATE(' 2017-03-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170327 values less than (TO_DATE(' 2017-03-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170328 values less than (TO_DATE(' 2017-03-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170329 values less than (TO_DATE(' 2017-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170330 values less than (TO_DATE(' 2017-03-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170331 values less than (TO_DATE(' 2017-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170401 values less than (TO_DATE(' 2017-04-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170402 values less than (TO_DATE(' 2017-04-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170403 values less than (TO_DATE(' 2017-04-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170404 values less than (TO_DATE(' 2017-04-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170405 values less than (TO_DATE(' 2017-04-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170406 values less than (TO_DATE(' 2017-04-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170407 values less than (TO_DATE(' 2017-04-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170408 values less than (TO_DATE(' 2017-04-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170409 values less than (TO_DATE(' 2017-04-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170410 values less than (TO_DATE(' 2017-04-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170411 values less than (TO_DATE(' 2017-04-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170412 values less than (TO_DATE(' 2017-04-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170413 values less than (TO_DATE(' 2017-04-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170414 values less than (TO_DATE(' 2017-04-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170415 values less than (TO_DATE(' 2017-04-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170416 values less than (TO_DATE(' 2017-04-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170417 values less than (TO_DATE(' 2017-04-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170418 values less than (TO_DATE(' 2017-04-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170419 values less than (TO_DATE(' 2017-04-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170420 values less than (TO_DATE(' 2017-04-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170421 values less than (TO_DATE(' 2017-04-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170422 values less than (TO_DATE(' 2017-04-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170423 values less than (TO_DATE(' 2017-04-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170424 values less than (TO_DATE(' 2017-04-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170425 values less than (TO_DATE(' 2017-04-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170426 values less than (TO_DATE(' 2017-04-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170427 values less than (TO_DATE(' 2017-04-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170428 values less than (TO_DATE(' 2017-04-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170429 values less than (TO_DATE(' 2017-04-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170430 values less than (TO_DATE(' 2017-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170501 values less than (TO_DATE(' 2017-05-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170502 values less than (TO_DATE(' 2017-05-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170503 values less than (TO_DATE(' 2017-05-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170504 values less than (TO_DATE(' 2017-05-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170505 values less than (TO_DATE(' 2017-05-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170506 values less than (TO_DATE(' 2017-05-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170507 values less than (TO_DATE(' 2017-05-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170508 values less than (TO_DATE(' 2017-05-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170509 values less than (TO_DATE(' 2017-05-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170510 values less than (TO_DATE(' 2017-05-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170511 values less than (TO_DATE(' 2017-05-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170512 values less than (TO_DATE(' 2017-05-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170513 values less than (TO_DATE(' 2017-05-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170514 values less than (TO_DATE(' 2017-05-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170515 values less than (TO_DATE(' 2017-05-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170516 values less than (TO_DATE(' 2017-05-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170517 values less than (TO_DATE(' 2017-05-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170518 values less than (TO_DATE(' 2017-05-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170519 values less than (TO_DATE(' 2017-05-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170520 values less than (TO_DATE(' 2017-05-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170521 values less than (TO_DATE(' 2017-05-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170522 values less than (TO_DATE(' 2017-05-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170523 values less than (TO_DATE(' 2017-05-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170524 values less than (TO_DATE(' 2017-05-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170525 values less than (TO_DATE(' 2017-05-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170526 values less than (TO_DATE(' 2017-05-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170527 values less than (TO_DATE(' 2017-05-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170528 values less than (TO_DATE(' 2017-05-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170529 values less than (TO_DATE(' 2017-05-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170530 values less than (TO_DATE(' 2017-05-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170531 values less than (TO_DATE(' 2017-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170601 values less than (TO_DATE(' 2017-06-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170602 values less than (TO_DATE(' 2017-06-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170603 values less than (TO_DATE(' 2017-06-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170604 values less than (TO_DATE(' 2017-06-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170605 values less than (TO_DATE(' 2017-06-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170606 values less than (TO_DATE(' 2017-06-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170607 values less than (TO_DATE(' 2017-06-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170608 values less than (TO_DATE(' 2017-06-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170609 values less than (TO_DATE(' 2017-06-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170610 values less than (TO_DATE(' 2017-06-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170611 values less than (TO_DATE(' 2017-06-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170612 values less than (TO_DATE(' 2017-06-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170613 values less than (TO_DATE(' 2017-06-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170614 values less than (TO_DATE(' 2017-06-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170615 values less than (TO_DATE(' 2017-06-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170616 values less than (TO_DATE(' 2017-06-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170617 values less than (TO_DATE(' 2017-06-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170618 values less than (TO_DATE(' 2017-06-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170619 values less than (TO_DATE(' 2017-06-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170620 values less than (TO_DATE(' 2017-06-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170621 values less than (TO_DATE(' 2017-06-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170622 values less than (TO_DATE(' 2017-06-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170623 values less than (TO_DATE(' 2017-06-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170624 values less than (TO_DATE(' 2017-06-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170625 values less than (TO_DATE(' 2017-06-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170626 values less than (TO_DATE(' 2017-06-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170627 values less than (TO_DATE(' 2017-06-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170628 values less than (TO_DATE(' 2017-06-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170629 values less than (TO_DATE(' 2017-06-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170630 values less than (TO_DATE(' 2017-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170701 values less than (TO_DATE(' 2017-07-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170702 values less than (TO_DATE(' 2017-07-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170703 values less than (TO_DATE(' 2017-07-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170704 values less than (TO_DATE(' 2017-07-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170705 values less than (TO_DATE(' 2017-07-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170706 values less than (TO_DATE(' 2017-07-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170707 values less than (TO_DATE(' 2017-07-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170708 values less than (TO_DATE(' 2017-07-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170709 values less than (TO_DATE(' 2017-07-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170710 values less than (TO_DATE(' 2017-07-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170711 values less than (TO_DATE(' 2017-07-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170712 values less than (TO_DATE(' 2017-07-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170713 values less than (TO_DATE(' 2017-07-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170714 values less than (TO_DATE(' 2017-07-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170715 values less than (TO_DATE(' 2017-07-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170716 values less than (TO_DATE(' 2017-07-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170717 values less than (TO_DATE(' 2017-07-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170718 values less than (TO_DATE(' 2017-07-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170719 values less than (TO_DATE(' 2017-07-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170720 values less than (TO_DATE(' 2017-07-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170721 values less than (TO_DATE(' 2017-07-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170722 values less than (TO_DATE(' 2017-07-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170723 values less than (TO_DATE(' 2017-07-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170724 values less than (TO_DATE(' 2017-07-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170725 values less than (TO_DATE(' 2017-07-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170726 values less than (TO_DATE(' 2017-07-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170727 values less than (TO_DATE(' 2017-07-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170728 values less than (TO_DATE(' 2017-07-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170729 values less than (TO_DATE(' 2017-07-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170730 values less than (TO_DATE(' 2017-07-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170731 values less than (TO_DATE(' 2017-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX,
  partition P20170801 values less than (TO_DATE(' 2017-08-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace MDCS_INDEX
);
comment on column MDCSCENTER.RECORD.TGSJ
  is '通过时间';
comment on column MDCSCENTER.RECORD.HPHM
  is '号牌号码';
comment on column MDCSCENTER.RECORD.CS
  is '车速';
comment on column MDCSCENTER.RECORD.CC
  is '车长';
comment on column MDCSCENTER.RECORD.HPYS
  is '号牌颜色';
comment on column MDCSCENTER.RECORD.CDBH
  is '车道编号';
comment on column MDCSCENTER.RECORD.DKDM
  is '道口代码';
comment on column MDCSCENTER.RECORD.TPURL
  is '图片地址';
comment on column MDCSCENTER.RECORD.WFXW
  is '违法类型 0-卡口，1-超速，4-闯红灯';
comment on column MDCSCENTER.RECORD.XS
  is '限速';
comment on column MDCSCENTER.RECORD.XSFX
  is '行驶方向';
comment on column MDCSCENTER.RECORD.HPSL
  is '号牌数量';
comment on column MDCSCENTER.RECORD.HPJG
  is '号牌结构:1－单排 2－武警 3－警用 4－双排  5－其他';
comment on column MDCSCENTER.RECORD.CSYS
  is '车身颜色';
comment on column MDCSCENTER.RECORD.CDLX
  is '车道类型0-机动车道，1-非机动车道';
comment on column MDCSCENTER.RECORD.CB
  is '车标 见CODE';
comment on column MDCSCENTER.RECORD.XRYZYS
  is '行人衣着颜色';
comment on column MDCSCENTER.RECORD.CSYSSX
  is '车身颜色深浅 0-未知，1-浅，2-深';
comment on column MDCSCENTER.RECORD.SBZT
  is '识别状态。1－识别成功 0－不成功 2－不完整';
comment on column MDCSCENTER.RECORD.SBSJ
  is '识别时间';
comment on column MDCSCENTER.RECORD.LX
  is '车辆类型';
comment on column MDCSCENTER.RECORD.SBBH
  is '设备编号';
comment on column MDCSCENTER.RECORD.SJZT
  is '代码：0-未审核；1-审核通过；2-审核不通过；3-申领中；4-已申领；缺省值：0';
comment on column MDCSCENTER.RECORD.SLSJ
  is '申领时间';
comment on column MDCSCENTER.RECORD.SHSJ
  is '审核时间';
comment on column MDCSCENTER.RECORD.SHR
  is '审核人（申领人）';
comment on column MDCSCENTER.RECORD.STARTDATE
  is '起始时间';
comment on column MDCSCENTER.RECORD.ENDDATE
  is '终止时间';
comment on column MDCSCENTER.RECORD.DATENUMBER
  is '时间之差';
comment on column MDCSCENTER.RECORD.GXSJ
  is '入本地数据库时间';
comment on column MDCSCENTER.RECORD.TPSL
  is '图片数量';
comment on column MDCSCENTER.RECORD.TPURL1
  is '图片地址(内网图片地址)';
create index MDCSCENTER.IDX_RECORD_TGSJ_CB on MDCSCENTER.RECORD (TGSJ DESC, CB);
create index MDCSCENTER.IDX_RECORD_TGSJ_CSYS on MDCSCENTER.RECORD (TGSJ DESC, CSYS);
create index MDCSCENTER.IDX_RECORD_TGSJ_DKDM on MDCSCENTER.RECORD (TGSJ DESC, DKDM);
create index MDCSCENTER.IDX_RECORD_TGSJ_DKDM_XSFX on MDCSCENTER.RECORD (TGSJ DESC, DKDM, XSFX);
create index MDCSCENTER.IDX_RECORD_TGSJ_HPHM on MDCSCENTER.RECORD (TGSJ DESC, HPHM);
create index MDCSCENTER.IDX_RECORD_TGSJ_HPYS on MDCSCENTER.RECORD (TGSJ DESC, HPYS);
create index MDCSCENTER.PK_RECORD_ID on MDCSCENTER.RECORD (ID);




spool off

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29578568/viewspace-2138088/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： oracle迁移表到新的表空间-包含表空间、索引、表分区
下一篇： 恢复到特定点（时间点、scn、日志序列号），rman不完全恢复
请登录后发表评论 登录
全部评论
wg0411

注册时间：2014-03-31

  • 博文量
    235
  • 访问量
    536115

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593