按月创建分区表

create table DW_CMCC_BILL_MONTH_T
(
  BUSINESS_MONTH      VARCHAR2(16) not null,
  BUSINESS_ID         NUMBER(16) default 0,
  BUSINESS_NAME       VARCHAR2(100),
  CHILD_BUSINESS_ID   NUMBER(16) default 0,
  CHILD_BUSINESS_NAME VARCHAR2(100),
  PAY_TYPE_ID         NUMBER(16) default 0,
  PAY_TYPE            VARCHAR2(100),
  PRICE               NUMBER(20,2) default 0,
  CP_ID               NUMBER(16) default 0,
  CP_NAME             VARCHAR2(100),
  REPORT_VERSION      NUMBER(4) default 0,
  USE_ACCORD          NUMBER(20) default 0,
  ACCORD_COST         NUMBER(20,2) default 0,
  STATE               CHAR(2) default '0'
)
PARTITION BY Range(BUSINESS_MONTH)
(
PARTITION PART_CMCC_BILL_MONTH_201201 VALUES LESS THAN ('201202'),
PARTITION PART_CMCC_BILL_MONTH_201202 VALUES LESS THAN ('201203'),
PARTITION PART_CMCC_BILL_MONTH_201203 VALUES LESS THAN ('201204'),
PARTITION PART_CMCC_BILL_MONTH_201204 VALUES LESS THAN ('201205'),
PARTITION PART_CMCC_BILL_MONTH_201205 VALUES LESS THAN ('201206'),
PARTITION PART_CMCC_BILL_MONTH_201206 VALUES LESS THAN ('201207'),
PARTITION PART_CMCC_BILL_MONTH_201207 VALUES LESS THAN ('201208'),
PARTITION PART_CMCC_BILL_MONTH_201208 VALUES LESS THAN ('201209'),
PARTITION PART_CMCC_BILL_MONTH_201209 VALUES LESS THAN ('201210'),
PARTITION PART_CMCC_BILL_MONTH_201210 VALUES LESS THAN ('201211'),
PARTITION PART_CMCC_BILL_MONTH_201211 VALUES LESS THAN ('201212'),
PARTITION PART_CMCC_BILL_MONTH_201212 VALUES LESS THAN ('201301'),


PARTITION PART_CMCC_BILL_MONTH_201301 VALUES LESS THAN ('201302'),
PARTITION PART_CMCC_BILL_MONTH_201302 VALUES LESS THAN ('201303'),
PARTITION PART_CMCC_BILL_MONTH_201303 VALUES LESS THAN ('201304'),
PARTITION PART_CMCC_BILL_MONTH_201304 VALUES LESS THAN ('201305'),
PARTITION PART_CMCC_BILL_MONTH_201305 VALUES LESS THAN ('201306'),
PARTITION PART_CMCC_BILL_MONTH_201306 VALUES LESS THAN ('201307'),
PARTITION PART_CMCC_BILL_MONTH_201307 VALUES LESS THAN ('201308'),
PARTITION PART_CMCC_BILL_MONTH_201308 VALUES LESS THAN ('201309'),
PARTITION PART_CMCC_BILL_MONTH_201309 VALUES LESS THAN ('201310'),
PARTITION PART_CMCC_BILL_MONTH_201310 VALUES LESS THAN ('201311'),
PARTITION PART_CMCC_BILL_MONTH_201311 VALUES LESS THAN ('201312'),
PARTITION PART_CMCC_BILL_MONTH_201312 VALUES LESS THAN ('201401'),




PARTITION PART_CMCC_BILL_MONTH_MAXVALUE VALUES LESS THAN (MAXVALUE)
);