程序博客网 > 尼古丁 知乎

list分区表转化为list-list组合分区表的测试过程

来源：互联网 发布：尼古丁 知乎 编辑：程序博客网 时间：2024/05/22 03:15
list分区表转化为list-list组合分区表的测试过程
1，创建测试表(list分区表)


create table TB_USS_JOB_TEST
(
  DOMAIN_NAME             VARCHAR2(50 BYTE),
  CREATE_DATE             DATE default sysdate,
  FROM_DATE               VARCHAR2(100),
  TO_DATE                 VARCHAR2(100) default '-',
  PRODUCT                 VARCHAR2(100),
  LANGUAGE                VARCHAR2(100) default '-',
  PLATFORM                VARCHAR2(100) default '-',
  OPERATINGLINE           VARCHAR2(100) default '-',
  CHANNEL                 VARCHAR2(100) default '-',
  SUB_CHANNEL             VARCHAR2(100) default '-',
  PAY_TYPE                VARCHAR2(100) default '-',
  SERVER                  VARCHAR2(100) default '-',
  CLIENT_VERSION          VARCHAR2(100) default '-',
  SERVICE                 VARCHAR2(100) default '-',
  EXTEND                  VARCHAR2(100) default '-',
  LOCALE                  VARCHAR2(50 BYTE) default '-',
  PROVINCE                VARCHAR2(50 BYTE) default '-',
  CITY                    VARCHAR2(50 BYTE) default '-',
  ACTION                  VARCHAR2(50 BYTE) default '-',
  CONSUME_TYPE            VARCHAR2(50 BYTE) default '-',
  SCENE                   VARCHAR2(50 BYTE) default '-',
  DIM1                    VARCHAR2(50 BYTE) default '-',
  DIM2                    VARCHAR2(50 BYTE) default '-',
  DIM3                    VARCHAR2(50 BYTE) default '-',
  DIM4                    VARCHAR2(50 BYTE) default '-',
  DIM5                    VARCHAR2(50 BYTE) default '-',
  INCOME                  NUMBER(20) default 0,
  CONSUME                 NUMBER(20) default 0,
  FIR_LOGIN_ACC_INC       NUMBER(20) default 0,
  FIR_PAY_ROLE_INC        NUMBER(20) default 0,
  FIR_PAY_ACC_INC         NUMBER(20) default 0,
  PAY_ACC_COUNT           NUMBER(20) default 0,
  PAY_ROLE_COUNT          NUMBER(20) default 0,
  PAY_DEVICE_COUNT        NUMBER(20) default 0,
  FIR_PAY_ACC_COUNT       NUMBER(20) default 0,
  FIR_PAY_ROLE_COUNT      NUMBER(20) default 0,
  FIR_LOGIN_ACC_PAY_COUNT NUMBER(20) default 0,
  REG_ROLE_PAY_COUNT      NUMBER(20) default 0,
  SUCC_ORDER_COUNT        NUMBER(20) default 0,
  LANUCH_DEV_COUNT        NUMBER(20) default 0,
  FIR_LANUCH_DEV_COUNT    NUMBER(20) default 0,
  REG_ROLE_COUNT          NUMBER(20) default 0,
  FIR_LOGIN_ACC_COUNT     NUMBER(20) default 0,
  FIR_LOGIN_DEV_COUNT     NUMBER(20) default 0,
  FIR_REG_DEV_COUNT       NUMBER(20) default 0,
  LOGIN_ROLE_COUNT        NUMBER(20) default 0,
  LOGIN_DEV_COUNT         NUMBER(20) default 0,
  LOGIN_ACC_COUNT         NUMBER(20) default 0,
  FIR_LOGIN_ROLE_COUNT    NUMBER(20) default 0,
  ACU                     NUMBER(20) default 0,
  PCU                     NUMBER(20) default 0,
  PCU_TIME                DATE,
  ZTS                     NUMBER(20) default 0,
  DIAMOND_STOCK           NUMBER(20) default 0,
  DIAMOND_CONSUME         NUMBER(20) default 0,
  NEW_REAL_DIAMOND        NUMBER(20) default 0,
  SCENCE_ADD_COUNT        NUMBER(20) default 0,
  SCENCE_BUY_COUNT        NUMBER(20) default 0,
  SCENCE_REMOVE_COUNT     NUMBER(20) default 0,
  ACCEPTED_COUNT          NUMBER(20) default 0,
  COMPLETED_COUNT         NUMBER(20) default 0,
  IND1                    NUMBER(20) default 0,
  IND2                    NUMBER(20) default 0,
  IND3                    NUMBER(20) default 0,
  IND4                    NUMBER(20) default 0,
  IND5                    NUMBER(20) default 0,
  VERSION                 VARCHAR2(100) default '00',
  DEVICE                  VARCHAR2(50 BYTE) default '-',
  CHARGEUNIT              VARCHAR2(50 BYTE) default '-',
  DOWNLOAD_COUNT          NUMBER,
  PV_COUNT                NUMBER,
  COUNTRY                 VARCHAR2(50 BYTE) default '-'
)
partition by list (DOMAIN_NAME)
(
  partition P_1 values ('day'),
  partition P_2 values ('month'),
  partition P_3 values ('week'),
  partition P_4 values ('time'),
  partition PDEFAULT values (default)
);






insert into TB_USS_JOB_TEST select * from TB_USS_JOB_data where rownum <1000;


commit;


select * from user_part_tables where table_name ='TB_USS_JOB_TEST';


2，创建list-list的组合分区


create table TB_USS_JOB_DATA_PART
(
  DOMAIN_NAME             VARCHAR2(50) not null,
  CREATE_DATE             DATE default sysdate,
  FROM_DATE               VARCHAR2(50) not null,
  TO_DATE                 VARCHAR2(50) default '-',
  PRODUCT                 VARCHAR2(50) not null,
  LANGUAGE                VARCHAR2(50) default '-',
  PLATFORM                VARCHAR2(50) default '-',
  OPERATINGLINE           VARCHAR2(50) default '-',
  CHANNEL                 VARCHAR2(50) default '-',
  SUB_CHANNEL             VARCHAR2(50) default '-',
  PAY_TYPE                VARCHAR2(50) default '-',
  SERVER                  VARCHAR2(50) default '-',
  CLIENT_VERSION          VARCHAR2(50) default '-',
  SERVICE                 VARCHAR2(50) default '-',
  EXTEND                  VARCHAR2(50) default '-',
  LOCALE                  VARCHAR2(50) default '-',
  PROVINCE                VARCHAR2(50) default '-',
  CITY                    VARCHAR2(50) default '-',
  ACTION                  VARCHAR2(50) default '-',
  CONSUME_TYPE            VARCHAR2(50) default '-',
  SCENE                   VARCHAR2(50) default '-',
  DIM1                    VARCHAR2(50) default '-',
  DIM2                    VARCHAR2(50) default '-',
  DIM3                    VARCHAR2(50) default '-',
  DIM4                    VARCHAR2(50) default '-',
  DIM5                    VARCHAR2(50) default '-',
  INCOME                  NUMBER(20) default 0,
  CONSUME                 NUMBER(20) default 0,
  FIR_LOGIN_ACC_INC       NUMBER(20) default 0,
  FIR_PAY_ROLE_INC        NUMBER(20) default 0,
  FIR_PAY_ACC_INC         NUMBER(20) default 0,
  PAY_ACC_COUNT           NUMBER(20) default 0,
  PAY_ROLE_COUNT          NUMBER(20) default 0,
  PAY_DEVICE_COUNT        NUMBER(20) default 0,
  FIR_PAY_ACC_COUNT       NUMBER(20) default 0,
  FIR_PAY_ROLE_COUNT      NUMBER(20) default 0,
  FIR_LOGIN_ACC_PAY_COUNT NUMBER(20) default 0,
  REG_ROLE_PAY_COUNT      NUMBER(20) default 0,
  SUCC_ORDER_COUNT        NUMBER(20) default 0,
  LANUCH_DEV_COUNT        NUMBER(20) default 0,
  FIR_LANUCH_DEV_COUNT    NUMBER(20) default 0,
  REG_ROLE_COUNT          NUMBER(20) default 0,
  FIR_LOGIN_ACC_COUNT     NUMBER(20) default 0,
  FIR_LOGIN_DEV_COUNT     NUMBER(20) default 0,
  FIR_REG_DEV_COUNT       NUMBER(20) default 0,
  LOGIN_ROLE_COUNT        NUMBER(20) default 0,
  LOGIN_DEV_COUNT         NUMBER(20) default 0,
  LOGIN_ACC_COUNT         NUMBER(20) default 0,
  FIR_LOGIN_ROLE_COUNT    NUMBER(20) default 0,
  ACU                     NUMBER(20) default 0,
  PCU                     NUMBER(20) default 0,
  PCU_TIME                DATE,
  ZTS                     NUMBER(20) default 0,
  DIAMOND_STOCK           NUMBER(20) default 0,
  DIAMOND_CONSUME         NUMBER(20) default 0,
  NEW_REAL_DIAMOND        NUMBER(20) default 0,
  SCENCE_ADD_COUNT        NUMBER(20) default 0,
  SCENCE_BUY_COUNT        NUMBER(20) default 0,
  SCENCE_REMOVE_COUNT     NUMBER(20) default 0,
  ACCEPTED_COUNT          NUMBER(20) default 0,
  COMPLETED_COUNT         NUMBER(20) default 0,
  IND1                    NUMBER(20) default 0,
  IND2                    NUMBER(20) default 0,
  IND3                    NUMBER(20) default 0,
  IND4                    NUMBER(20) default 0,
  IND5                    NUMBER(20) default 0
)
partition by list (DOMAIN_NAME)
subpartition by list (FROM_DATE)
subpartition template
(
    subpartition P_20140101 values ('20140101') tablespace oslog,
    subpartition P_20140102 values ('20140102') tablespace oslog,
    subpartition P_20140103 values ('20140103') tablespace oslog,
    subpartition P_20140104 values ('20140104') tablespace oslog,
    subpartition P_20140105 values ('20140105') tablespace oslog,
    subpartition P_20140106 values ('20140106') tablespace oslog,
    subpartition P_20140107 values ('20140107') tablespace oslog,
    subpartition P_20140108 values ('20140108') tablespace oslog,
    subpartition P_20140109 values ('20140109') tablespace oslog,
    subpartition P_20140110 values ('20140110') tablespace oslog,
    subpartition P_20140111 values ('20140111') tablespace oslog,
    subpartition P_20140112 values ('20140112') tablespace oslog,
    subpartition P_20140113 values ('20140113') tablespace oslog,
    subpartition P_20140114 values ('20140114') tablespace oslog,
    subpartition P_20140115 values ('20140115') tablespace oslog,
    subpartition P_20140116 values ('20140116') tablespace oslog,
    subpartition P_20140117 values ('20140117') tablespace oslog,
    subpartition P_20140118 values ('20140118') tablespace oslog,
    subpartition P_20140119 values ('20140119') tablespace oslog,
    subpartition P_20140120 values ('20140120') tablespace oslog,
    subpartition P_20140121 values ('20140121') tablespace oslog,
    subpartition P_20140122 values ('20140122') tablespace oslog,
    subpartition P_20140123 values ('20140123') tablespace oslog,
    subpartition P_20140124 values ('20140124') tablespace oslog,
    subpartition P_20140125 values ('20140125') tablespace oslog,
    subpartition P_20140126 values ('20140126') tablespace oslog,
    subpartition P_20140127 values ('20140127') tablespace oslog,
    subpartition P_20140128 values ('20140128') tablespace oslog,
    subpartition P_20140129 values ('20140129') tablespace oslog,
    subpartition P_20140130 values ('20140130') tablespace oslog,
    subpartition P_20140131 values ('20140131') tablespace oslog,
    subpartition P_20140201 values ('20140201') tablespace oslog,
    subpartition P_20140202 values ('20140202') tablespace oslog,
    subpartition P_20140203 values ('20140203') tablespace oslog,
    subpartition P_20140204 values ('20140204') tablespace oslog,
    subpartition P_20140205 values ('20140205') tablespace oslog,
    subpartition P_20140206 values ('20140206') tablespace oslog,
    subpartition P_20140207 values ('20140207') tablespace oslog,
    subpartition P_20140208 values ('20140208') tablespace oslog,
    subpartition P_20140209 values ('20140209') tablespace oslog,
    subpartition P_20140210 values ('20140210') tablespace oslog,
    subpartition P_20140211 values ('20140211') tablespace oslog,
    subpartition P_20140212 values ('20140212') tablespace oslog,
    subpartition P_20140213 values ('20140213') tablespace oslog,
    subpartition P_20140214 values ('20140214') tablespace oslog,
    subpartition P_20140215 values ('20140215') tablespace oslog,
    subpartition P_20140216 values ('20140216') tablespace oslog,
    subpartition P_20140217 values ('20140217') tablespace oslog,
    subpartition P_20140218 values ('20140218') tablespace oslog,
    subpartition P_20140219 values ('20140219') tablespace oslog,
    subpartition P_20140220 values ('20140220') tablespace oslog,
    subpartition P_20140221 values ('20140221') tablespace oslog,
    subpartition P_20140222 values ('20140222') tablespace oslog,
    subpartition P_20140223 values ('20140223') tablespace oslog,
    subpartition P_20140224 values ('20140224') tablespace oslog,
    subpartition P_20140225 values ('20140225') tablespace oslog,
    subpartition P_20140226 values ('20140226') tablespace oslog,
    subpartition P_20140227 values ('20140227') tablespace oslog,
    subpartition P_20140228 values ('20140228') tablespace oslog,
    subpartition P_20140301 values ('20140301') tablespace oslog,
    subpartition P_20140302 values ('20140302') tablespace oslog,
    subpartition P_20140303 values ('20140303') tablespace oslog,
    subpartition P_20140304 values ('20140304') tablespace oslog,
    subpartition P_20140305 values ('20140305') tablespace oslog,
    subpartition P_20140306 values ('20140306') tablespace oslog,
    subpartition P_20140307 values ('20140307') tablespace oslog,
    subpartition P_20140308 values ('20140308') tablespace oslog,
    subpartition P_20140309 values ('20140309') tablespace oslog,
    subpartition P_20140310 values ('20140310') tablespace oslog,
    subpartition P_20140311 values ('20140311') tablespace oslog,
    subpartition P_20140312 values ('20140312') tablespace oslog,
    subpartition P_20140313 values ('20140313') tablespace oslog,
    subpartition P_20140314 values ('20140314') tablespace oslog,
    subpartition P_20140315 values ('20140315') tablespace oslog,
    subpartition P_20140316 values ('20140316') tablespace oslog,
    subpartition P_20140317 values ('20140317') tablespace oslog,
    subpartition P_20140318 values ('20140318') tablespace oslog,
    subpartition P_20140319 values ('20140319') tablespace oslog,
    subpartition P_20140320 values ('20140320') tablespace oslog,
    subpartition P_20140321 values ('20140321') tablespace oslog,
    subpartition P_20140322 values ('20140322') tablespace oslog,
    subpartition P_20140323 values ('20140323') tablespace oslog,
    subpartition P_20140324 values ('20140324') tablespace oslog,
    subpartition P_20140325 values ('20140325') tablespace oslog,
    subpartition P_20140326 values ('20140326') tablespace oslog,
    subpartition P_20140327 values ('20140327') tablespace oslog,
    subpartition P_20140328 values ('20140328') tablespace oslog,
    subpartition P_20140329 values ('20140329') tablespace oslog,
    subpartition P_20140330 values ('20140330') tablespace oslog,
    subpartition P_20140331 values ('20140331') tablespace oslog,
    subpartition P_20140401 values ('20140401') tablespace oslog,
    subpartition P_20140402 values ('20140402') tablespace oslog,
    subpartition P_20140403 values ('20140403') tablespace oslog,
    subpartition P_20140404 values ('20140404') tablespace oslog,
    subpartition P_20140405 values ('20140405') tablespace oslog,
    subpartition P_20140406 values ('20140406') tablespace oslog,
    subpartition P_20140407 values ('20140407') tablespace oslog,
    subpartition P_20140408 values ('20140408') tablespace oslog,
    subpartition P_20140409 values ('20140409') tablespace oslog,
    subpartition P_20140410 values ('20140410') tablespace oslog,
    subpartition P_20140411 values ('20140411') tablespace oslog,
    subpartition P_20140412 values ('20140412') tablespace oslog,
    subpartition P_20140413 values ('20140413') tablespace oslog,
    subpartition P_20140414 values ('20140414') tablespace oslog,
    subpartition P_20140415 values ('20140415') tablespace oslog,
    subpartition P_20140416 values ('20140416') tablespace oslog,
    subpartition P_20140417 values ('20140417') tablespace oslog,
    subpartition P_20140418 values ('20140418') tablespace oslog,
    subpartition P_20140419 values ('20140419') tablespace oslog,
    subpartition P_20140420 values ('20140420') tablespace oslog,
    subpartition P_20140421 values ('20140421') tablespace oslog,
    subpartition P_20140422 values ('20140422') tablespace oslog,
    subpartition P_20140423 values ('20140423') tablespace oslog,
    subpartition P_20140424 values ('20140424') tablespace oslog,
    subpartition P_20140425 values ('20140425') tablespace oslog,
    subpartition P_20140426 values ('20140426') tablespace oslog,
    subpartition P_20140427 values ('20140427') tablespace oslog,
    subpartition P_20140428 values ('20140428') tablespace oslog,
    subpartition P_20140429 values ('20140429') tablespace oslog,
    subpartition P_20140430 values ('20140430') tablespace oslog,
    subpartition P_20140501 values ('20140501') tablespace oslog,
    subpartition P_20140502 values ('20140502') tablespace oslog,
    subpartition P_20140503 values ('20140503') tablespace oslog,
    subpartition P_20140504 values ('20140504') tablespace oslog,
    subpartition P_20140505 values ('20140505') tablespace oslog,
    subpartition P_20140506 values ('20140506') tablespace oslog,
    subpartition P_20140507 values ('20140507') tablespace oslog,
    subpartition P_20140508 values ('20140508') tablespace oslog,
    subpartition P_20140509 values ('20140509') tablespace oslog,
    subpartition P_20140510 values ('20140510') tablespace oslog,
    subpartition P_20140511 values ('20140511') tablespace oslog,
    subpartition P_20140512 values ('20140512') tablespace oslog,
    subpartition P_20140513 values ('20140513') tablespace oslog,
    subpartition P_20140514 values ('20140514') tablespace oslog,
    subpartition P_20140515 values ('20140515') tablespace oslog,
    subpartition P_20140516 values ('20140516') tablespace oslog,
    subpartition P_20140517 values ('20140517') tablespace oslog,
    subpartition P_20140518 values ('20140518') tablespace oslog,
    subpartition P_20140519 values ('20140519') tablespace oslog,
    subpartition P_20140520 values ('20140520') tablespace oslog,
    subpartition P_20140521 values ('20140521') tablespace oslog,
    subpartition P_20140522 values ('20140522') tablespace oslog,
    subpartition P_20140523 values ('20140523') tablespace oslog,
    subpartition P_20140524 values ('20140524') tablespace oslog,
    subpartition P_20140525 values ('20140525') tablespace oslog,
    subpartition P_20140526 values ('20140526') tablespace oslog,
    subpartition P_20140527 values ('20140527') tablespace oslog,
    subpartition P_20140528 values ('20140528') tablespace oslog,
    subpartition P_20140529 values ('20140529') tablespace oslog,
    subpartition P_20140530 values ('20140530') tablespace oslog,
    subpartition P_20140531 values ('20140531') tablespace oslog,
    subpartition P_20140601 values ('20140601') tablespace oslog,
    subpartition P_20140602 values ('20140602') tablespace oslog,
    subpartition P_20140603 values ('20140603') tablespace oslog,
    subpartition P_20140604 values ('20140604') tablespace oslog,
    subpartition P_20140605 values ('20140605') tablespace oslog,
    subpartition P_20140606 values ('20140606') tablespace oslog,
    subpartition P_20140607 values ('20140607') tablespace oslog,
    subpartition P_20140608 values ('20140608') tablespace oslog,
    subpartition P_20140609 values ('20140609') tablespace oslog,
    subpartition P_20140610 values ('20140610') tablespace oslog,
    subpartition P_20140611 values ('20140611') tablespace oslog,
    subpartition P_20140612 values ('20140612') tablespace oslog,
    subpartition P_20140613 values ('20140613') tablespace oslog,
    subpartition P_20140614 values ('20140614') tablespace oslog,
    subpartition P_20140615 values ('20140615') tablespace oslog,
    subpartition P_20140616 values ('20140616') tablespace oslog,
    subpartition P_20140617 values ('20140617') tablespace oslog,
    subpartition P_20140618 values ('20140618') tablespace oslog,
    subpartition P_20140619 values ('20140619') tablespace oslog,
    subpartition P_20140620 values ('20140620') tablespace oslog,
    subpartition P_20140621 values ('20140621') tablespace oslog,
    subpartition P_20140622 values ('20140622') tablespace oslog,
    subpartition P_20140623 values ('20140623') tablespace oslog,
    subpartition P_20140624 values ('20140624') tablespace oslog,
    subpartition P_20140625 values ('20140625') tablespace oslog,
    subpartition P_20140626 values ('20140626') tablespace oslog,
    subpartition P_20140627 values ('20140627') tablespace oslog,
    subpartition P_20140628 values ('20140628') tablespace oslog,
    subpartition P_20140629 values ('20140629') tablespace oslog,
    subpartition P_20140630 values ('20140630') tablespace oslog,
    subpartition P_20140701 values ('20140701') tablespace oslog,
    subpartition P_20140702 values ('20140702') tablespace oslog,
    subpartition P_20140703 values ('20140703') tablespace oslog,
    subpartition P_20140704 values ('20140704') tablespace oslog,
    subpartition P_20140705 values ('20140705') tablespace oslog,
    subpartition P_20140706 values ('20140706') tablespace oslog,
    subpartition P_20140707 values ('20140707') tablespace oslog,
    subpartition P_20140708 values ('20140708') tablespace oslog,
    subpartition P_20140709 values ('20140709') tablespace oslog,
    subpartition P_20140710 values ('20140710') tablespace oslog,
    subpartition P_20140711 values ('20140711') tablespace oslog,
    subpartition P_20140712 values ('20140712') tablespace oslog,
    subpartition P_20140713 values ('20140713') tablespace oslog,
    subpartition P_20140714 values ('20140714') tablespace oslog,
    subpartition P_20140715 values ('20140715') tablespace oslog,
    subpartition P_20140716 values ('20140716') tablespace oslog,
    subpartition P_20140717 values ('20140717') tablespace oslog,
    subpartition P_20140718 values ('20140718') tablespace oslog,
    subpartition P_20140719 values ('20140719') tablespace oslog,
    subpartition P_20140720 values ('20140720') tablespace oslog,
    subpartition P_20140721 values ('20140721') tablespace oslog,
    subpartition P_20140722 values ('20140722') tablespace oslog,
    subpartition P_20140723 values ('20140723') tablespace oslog,
    subpartition P_20140724 values ('20140724') tablespace oslog,
    subpartition P_20140725 values ('20140725') tablespace oslog,
    subpartition P_20140726 values ('20140726') tablespace oslog,
    subpartition P_20140727 values ('20140727') tablespace oslog,
    subpartition P_20140728 values ('20140728') tablespace oslog,
    subpartition P_20140729 values ('20140729') tablespace oslog,
    subpartition P_20140730 values ('20140730') tablespace oslog,
    subpartition P_20140731 values ('20140731') tablespace oslog,
    subpartition P_20140801 values ('20140801') tablespace oslog,
    subpartition P_20140802 values ('20140802') tablespace oslog,
    subpartition P_20140803 values ('20140803') tablespace oslog,
    subpartition P_20140804 values ('20140804') tablespace oslog,
    subpartition P_20140805 values ('20140805') tablespace oslog,
    subpartition P_20140806 values ('20140806') tablespace oslog,
    subpartition P_20140807 values ('20140807') tablespace oslog,
    subpartition P_20140808 values ('20140808') tablespace oslog,
    subpartition P_20140809 values ('20140809') tablespace oslog,
    subpartition P_20140810 values ('20140810') tablespace oslog,
    subpartition P_20140811 values ('20140811') tablespace oslog,
    subpartition P_20140812 values ('20140812') tablespace oslog,
    subpartition P_20140813 values ('20140813') tablespace oslog,
    subpartition P_20140814 values ('20140814') tablespace oslog,
    subpartition P_20140815 values ('20140815') tablespace oslog,
    subpartition P_20140816 values ('20140816') tablespace oslog,
    subpartition P_20140817 values ('20140817') tablespace oslog,
    subpartition P_20140818 values ('20140818') tablespace oslog,
    subpartition P_20140819 values ('20140819') tablespace oslog,
    subpartition P_20140820 values ('20140820') tablespace oslog,
    subpartition P_20140821 values ('20140821') tablespace oslog,
    subpartition P_20140822 values ('20140822') tablespace oslog,
    subpartition P_20140823 values ('20140823') tablespace oslog,
    subpartition P_20140824 values ('20140824') tablespace oslog,
    subpartition P_20140825 values ('20140825') tablespace oslog,
    subpartition P_20140826 values ('20140826') tablespace oslog,
    subpartition P_20140827 values ('20140827') tablespace oslog,
    subpartition P_20140828 values ('20140828') tablespace oslog,
    subpartition P_20140829 values ('20140829') tablespace oslog,
    subpartition P_20140830 values ('20140830') tablespace oslog,
    subpartition P_20140831 values ('20140831') tablespace oslog,
    subpartition P_20140901 values ('20140901') tablespace oslog,
    subpartition P_20140902 values ('20140902') tablespace oslog,
    subpartition P_20140903 values ('20140903') tablespace oslog,
    subpartition P_20140904 values ('20140904') tablespace oslog,
    subpartition P_20140905 values ('20140905') tablespace oslog,
    subpartition P_20140906 values ('20140906') tablespace oslog,
    subpartition P_20140907 values ('20140907') tablespace oslog,
    subpartition P_20140908 values ('20140908') tablespace oslog,
    subpartition P_20140909 values ('20140909') tablespace oslog,
    subpartition P_20140910 values ('20140910') tablespace oslog,
    subpartition P_20140911 values ('20140911') tablespace oslog,
    subpartition P_20140912 values ('20140912') tablespace oslog,
    subpartition P_20140913 values ('20140913') tablespace oslog,
    subpartition P_20140914 values ('20140914') tablespace oslog,
    subpartition P_20140915 values ('20140915') tablespace oslog,
    subpartition P_20140916 values ('20140916') tablespace oslog,
    subpartition P_20140917 values ('20140917') tablespace oslog,
    subpartition P_20140918 values ('20140918') tablespace oslog,
    subpartition P_20140919 values ('20140919') tablespace oslog,
    subpartition P_20140920 values ('20140920') tablespace oslog,
    subpartition P_20140921 values ('20140921') tablespace oslog,
    subpartition P_20140922 values ('20140922') tablespace oslog,
    subpartition P_20140923 values ('20140923') tablespace oslog,
    subpartition P_20140924 values ('20140924') tablespace oslog,
    subpartition P_20140925 values ('20140925') tablespace oslog,
    subpartition P_20140926 values ('20140926') tablespace oslog,
    subpartition P_20140927 values ('20140927') tablespace oslog,
    subpartition P_20140928 values ('20140928') tablespace oslog,
    subpartition P_20140929 values ('20140929') tablespace oslog,
    subpartition P_20140930 values ('20140930') tablespace oslog,
    subpartition P_20141001 values ('20141001') tablespace oslog,
    subpartition P_20141002 values ('20141002') tablespace oslog,
    subpartition P_20141003 values ('20141003') tablespace oslog,
    subpartition P_20141004 values ('20141004') tablespace oslog,
    subpartition P_20141005 values ('20141005') tablespace oslog,
    subpartition P_20141006 values ('20141006') tablespace oslog,
    subpartition P_20141007 values ('20141007') tablespace oslog,
    subpartition P_20141008 values ('20141008') tablespace oslog,
    subpartition P_20141009 values ('20141009') tablespace oslog,
    subpartition P_20141010 values ('20141010') tablespace oslog,
    subpartition P_20141011 values ('20141011') tablespace oslog,
    subpartition P_20141012 values ('20141012') tablespace oslog,
    subpartition P_20141013 values ('20141013') tablespace oslog,
    subpartition P_20141014 values ('20141014') tablespace oslog,
    subpartition P_20141015 values ('20141015') tablespace oslog,
    subpartition P_20141016 values ('20141016') tablespace oslog,
    subpartition P_20141017 values ('20141017') tablespace oslog,
    subpartition P_20141018 values ('20141018') tablespace oslog,
    subpartition P_20141019 values ('20141019') tablespace oslog,
    subpartition P_20141020 values ('20141020') tablespace oslog,
    subpartition P_20141021 values ('20141021') tablespace oslog,
    subpartition P_20141022 values ('20141022') tablespace oslog,
    subpartition P_20141023 values ('20141023') tablespace oslog,
    subpartition P_20141024 values ('20141024') tablespace oslog,
    subpartition P_20141025 values ('20141025') tablespace oslog,
    subpartition P_20141026 values ('20141026') tablespace oslog,
    subpartition P_20141027 values ('20141027') tablespace oslog,
    subpartition P_20141028 values ('20141028') tablespace oslog,
    subpartition P_20141029 values ('20141029') tablespace oslog,
    subpartition P_20141030 values ('20141030') tablespace oslog,
    subpartition P_20141031 values ('20141031') tablespace oslog,
    subpartition P_20141101 values ('20141101') tablespace oslog,
    subpartition P_20141102 values ('20141102') tablespace oslog,
    subpartition P_20141103 values ('20141103') tablespace oslog,
    subpartition P_20141104 values ('20141104') tablespace oslog,
    subpartition P_20141105 values ('20141105') tablespace oslog,
    subpartition P_20141106 values ('20141106') tablespace oslog,
    subpartition P_20141107 values ('20141107') tablespace oslog,
    subpartition P_20141108 values ('20141108') tablespace oslog,
    subpartition P_20141109 values ('20141109') tablespace oslog,
    subpartition P_20141110 values ('20141110') tablespace oslog,
    subpartition P_20141111 values ('20141111') tablespace oslog,
    subpartition P_20141112 values ('20141112') tablespace oslog,
    subpartition P_20141113 values ('20141113') tablespace oslog,
    subpartition P_20141114 values ('20141114') tablespace oslog,
    subpartition P_20141115 values ('20141115') tablespace oslog,
    subpartition P_20141116 values ('20141116') tablespace oslog,
    subpartition P_20141117 values ('20141117') tablespace oslog,
    subpartition P_20141118 values ('20141118') tablespace oslog,
    subpartition P_20141119 values ('20141119') tablespace oslog,
    subpartition P_20141120 values ('20141120') tablespace oslog,
    subpartition P_20141121 values ('20141121') tablespace oslog,
    subpartition P_20141122 values ('20141122') tablespace oslog,
    subpartition P_20141123 values ('20141123') tablespace oslog,
    subpartition P_20141124 values ('20141124') tablespace oslog,
    subpartition P_20141125 values ('20141125') tablespace oslog,
    subpartition P_20141126 values ('20141126') tablespace oslog,
    subpartition P_20141127 values ('20141127') tablespace oslog,
    subpartition P_20141128 values ('20141128') tablespace oslog,
    subpartition P_20141129 values ('20141129') tablespace oslog,
    subpartition P_20141130 values ('20141130') tablespace oslog,
    subpartition P_20141201 values ('20141201') tablespace oslog,
    subpartition P_20141202 values ('20141202') tablespace oslog,
    subpartition P_20141203 values ('20141203') tablespace oslog,
    subpartition P_20141204 values ('20141204') tablespace oslog,
    subpartition P_20141205 values ('20141205') tablespace oslog,
    subpartition P_20141206 values ('20141206') tablespace oslog,
    subpartition P_20141207 values ('20141207') tablespace oslog,
    subpartition P_20141208 values ('20141208') tablespace oslog,
    subpartition P_20141209 values ('20141209') tablespace oslog,
    subpartition P_20141210 values ('20141210') tablespace oslog,
    subpartition P_20141211 values ('20141211') tablespace oslog,
    subpartition P_20141212 values ('20141212') tablespace oslog,
    subpartition P_20141213 values ('20141213') tablespace oslog,
    subpartition P_20141214 values ('20141214') tablespace oslog,
    subpartition P_20141215 values ('20141215') tablespace oslog,
    subpartition P_20141216 values ('20141216') tablespace oslog,
    subpartition P_20141217 values ('20141217') tablespace oslog,
    subpartition P_20141218 values ('20141218') tablespace oslog,
    subpartition P_20141219 values ('20141219') tablespace oslog,
    subpartition P_20141220 values ('20141220') tablespace oslog,
    subpartition P_20141221 values ('20141221') tablespace oslog,
    subpartition P_20141222 values ('20141222') tablespace oslog,
    subpartition P_20141223 values ('20141223') tablespace oslog,
    subpartition P_20141224 values ('20141224') tablespace oslog,
    subpartition P_20141225 values ('20141225') tablespace oslog,
    subpartition P_20141226 values ('20141226') tablespace oslog,
    subpartition P_20141227 values ('20141227') tablespace oslog,
    subpartition P_20141228 values ('20141228') tablespace oslog,
    subpartition P_20141229 values ('20141229') tablespace oslog,
    subpartition P_20141230 values ('20141230') tablespace oslog,
    subpartition P_20141231 values ('20141231') tablespace oslog,
    subpartition P_20150101 values ('20150101') tablespace oslog,
    subpartition P_20150102 values ('20150102') tablespace oslog,
    subpartition P_20150103 values ('20150103') tablespace oslog,
    subpartition P_20150104 values ('20150104') tablespace oslog,
    subpartition P_20150105 values ('20150105') tablespace oslog,
    subpartition P_20150106 values ('20150106') tablespace oslog,
    subpartition P_20150107 values ('20150107') tablespace oslog,
    subpartition P_20150108 values ('20150108') tablespace oslog,
    subpartition P_20150109 values ('20150109') tablespace oslog,
    subpartition P_20150110 values ('20150110') tablespace oslog,
    subpartition P_20150111 values ('20150111') tablespace oslog,
    subpartition P_20150112 values ('20150112') tablespace oslog,
    subpartition P_20150113 values ('20150113') tablespace oslog,
    subpartition P_20150114 values ('20150114') tablespace oslog,
    subpartition P_20150115 values ('20150115') tablespace oslog,
    subpartition P_20150116 values ('20150116') tablespace oslog,
    subpartition P_20150117 values ('20150117') tablespace oslog,
    subpartition P_20150118 values ('20150118') tablespace oslog,
    subpartition P_20150119 values ('20150119') tablespace oslog,
    subpartition P_20150120 values ('20150120') tablespace oslog,
    subpartition P_20150121 values ('20150121') tablespace oslog,
    subpartition P_20150122 values ('20150122') tablespace oslog,
    subpartition P_20150123 values ('20150123') tablespace oslog,
    subpartition P_20150124 values ('20150124') tablespace oslog,
    subpartition P_20150125 values ('20150125') tablespace oslog,
    subpartition P_20150126 values ('20150126') tablespace oslog,
    subpartition P_20150127 values ('20150127') tablespace oslog,
    subpartition P_20150128 values ('20150128') tablespace oslog,
    subpartition P_20150129 values ('20150129') tablespace oslog,
    subpartition P_20150130 values ('20150130') tablespace oslog,
    subpartition P_20150131 values ('20150131') tablespace oslog,
    subpartition P_20150201 values ('20150201') tablespace oslog,
    subpartition P_20150202 values ('20150202') tablespace oslog,
    subpartition P_20150203 values ('20150203') tablespace oslog,
    subpartition P_20150204 values ('20150204') tablespace oslog,
    subpartition P_20150205 values ('20150205') tablespace oslog,
    subpartition P_20150206 values ('20150206') tablespace oslog,
    subpartition P_20150207 values ('20150207') tablespace oslog,
    subpartition P_20150208 values ('20150208') tablespace oslog,
    subpartition P_20150209 values ('20150209') tablespace oslog,
    subpartition P_20150210 values ('20150210') tablespace oslog,
    subpartition P_20150211 values ('20150211') tablespace oslog,
    subpartition P_20150212 values ('20150212') tablespace oslog,
    subpartition P_20150213 values ('20150213') tablespace oslog,
    subpartition P_20150214 values ('20150214') tablespace oslog,
    subpartition P_20150215 values ('20150215') tablespace oslog,
    subpartition P_20150216 values ('20150216') tablespace oslog,
    subpartition P_20150217 values ('20150217') tablespace oslog,
    subpartition P_20150218 values ('20150218') tablespace oslog,
    subpartition P_20150219 values ('20150219') tablespace oslog,
    subpartition P_20150220 values ('20150220') tablespace oslog,
    subpartition P_20150221 values ('20150221') tablespace oslog,
    subpartition P_20150222 values ('20150222') tablespace oslog,
    subpartition P_20150223 values ('20150223') tablespace oslog,
    subpartition P_20150224 values ('20150224') tablespace oslog,
    subpartition P_20150225 values ('20150225') tablespace oslog,
    subpartition P_20150226 values ('20150226') tablespace oslog,
    subpartition P_20150227 values ('20150227') tablespace oslog,
    subpartition P_20150228 values ('20150228') tablespace oslog,
    subpartition P_20150301 values ('20150301') tablespace oslog,
    subpartition P_20150302 values ('20150302') tablespace oslog,
    subpartition P_20150303 values ('20150303') tablespace oslog,
    subpartition P_20150304 values ('20150304') tablespace oslog,
    subpartition P_20150305 values ('20150305') tablespace oslog,
    subpartition P_20150306 values ('20150306') tablespace oslog,
    subpartition P_20150307 values ('20150307') tablespace oslog,
    subpartition P_20150308 values ('20150308') tablespace oslog,
    subpartition P_20150309 values ('20150309') tablespace oslog,
    subpartition P_20150310 values ('20150310') tablespace oslog,
    subpartition P_20150311 values ('20150311') tablespace oslog,
    subpartition P_20150312 values ('20150312') tablespace oslog,
    subpartition P_20150313 values ('20150313') tablespace oslog,
    subpartition P_20150314 values ('20150314') tablespace oslog,
    subpartition P_20150315 values ('20150315') tablespace oslog,
    subpartition P_20150316 values ('20150316') tablespace oslog,
    subpartition P_20150317 values ('20150317') tablespace oslog,
    subpartition P_20150318 values ('20150318') tablespace oslog,
    subpartition P_20150319 values ('20150319') tablespace oslog,
    subpartition P_20150320 values ('20150320') tablespace oslog,
    subpartition P_20150321 values ('20150321') tablespace oslog,
    subpartition P_20150322 values ('20150322') tablespace oslog,
    subpartition P_20150323 values ('20150323') tablespace oslog,
    subpartition P_20150324 values ('20150324') tablespace oslog,
    subpartition P_20150325 values ('20150325') tablespace oslog,
    subpartition P_20150326 values ('20150326') tablespace oslog,
    subpartition P_20150327 values ('20150327') tablespace oslog,
    subpartition P_20150328 values ('20150328') tablespace oslog,
    subpartition P_20150329 values ('20150329') tablespace oslog,
    subpartition P_20150330 values ('20150330') tablespace oslog,
    subpartition P_20150331 values ('20150331') tablespace oslog,
    subpartition P_20150401 values ('20150401') tablespace oslog,
    subpartition P_20150402 values ('20150402') tablespace oslog,
    subpartition P_20150403 values ('20150403') tablespace oslog,
    subpartition P_20150404 values ('20150404') tablespace oslog,
    subpartition P_20150405 values ('20150405') tablespace oslog,
    subpartition P_20150406 values ('20150406') tablespace oslog,
    subpartition P_20150407 values ('20150407') tablespace oslog,
    subpartition P_20150408 values ('20150408') tablespace oslog,
    subpartition P_20150409 values ('20150409') tablespace oslog,
    subpartition P_20150410 values ('20150410') tablespace oslog,
    subpartition P_20150411 values ('20150411') tablespace oslog,
    subpartition P_20150412 values ('20150412') tablespace oslog,
    subpartition P_20150413 values ('20150413') tablespace oslog,
    subpartition P_20150414 values ('20150414') tablespace oslog,
    subpartition P_20150415 values ('20150415') tablespace oslog,
    subpartition P_20150416 values ('20150416') tablespace oslog,
    subpartition P_20150417 values ('20150417') tablespace oslog,
    subpartition P_20150418 values ('20150418') tablespace oslog,
    subpartition P_20150419 values ('20150419') tablespace oslog,
    subpartition P_20150420 values ('20150420') tablespace oslog,
    subpartition P_20150421 values ('20150421') tablespace oslog,
    subpartition P_20150422 values ('20150422') tablespace oslog,
    subpartition P_20150423 values ('20150423') tablespace oslog,
    subpartition P_20150424 values ('20150424') tablespace oslog,
    subpartition P_20150425 values ('20150425') tablespace oslog,
    subpartition P_20150426 values ('20150426') tablespace oslog,
    subpartition P_20150427 values ('20150427') tablespace oslog,
    subpartition P_20150428 values ('20150428') tablespace oslog,
    subpartition P_20150429 values ('20150429') tablespace oslog,
    subpartition P_20150430 values ('20150430') tablespace oslog,
    subpartition P_20150501 values ('20150501') tablespace oslog,
    subpartition P_20150502 values ('20150502') tablespace oslog,
    subpartition P_20150503 values ('20150503') tablespace oslog,
    subpartition P_20150504 values ('20150504') tablespace oslog,
    subpartition P_20150505 values ('20150505') tablespace oslog,
    subpartition P_20150506 values ('20150506') tablespace oslog,
    subpartition P_20150507 values ('20150507') tablespace oslog,
    subpartition P_20150508 values ('20150508') tablespace oslog,
    subpartition P_20150509 values ('20150509') tablespace oslog,
    subpartition P_20150510 values ('20150510') tablespace oslog,
    subpartition P_20150511 values ('20150511') tablespace oslog,
    subpartition P_20150512 values ('20150512') tablespace oslog,
    subpartition P_20150513 values ('20150513') tablespace oslog,
    subpartition P_20150514 values ('20150514') tablespace oslog,
    subpartition P_20150515 values ('20150515') tablespace oslog,
    subpartition P_20150516 values ('20150516') tablespace oslog,
    subpartition P_20150517 values ('20150517') tablespace oslog,
    subpartition P_20150518 values ('20150518') tablespace oslog,
    subpartition P_20150519 values ('20150519') tablespace oslog,
    subpartition P_20150520 values ('20150520') tablespace oslog,
    subpartition P_20150521 values ('20150521') tablespace oslog,
    subpartition P_20150522 values ('20150522') tablespace oslog,
    subpartition P_20150523 values ('20150523') tablespace oslog,
    subpartition P_20150524 values ('20150524') tablespace oslog,
    subpartition P_20150525 values ('20150525') tablespace oslog,
    subpartition P_20150526 values ('20150526') tablespace oslog,
    subpartition P_20150527 values ('20150527') tablespace oslog,
    subpartition P_20150528 values ('20150528') tablespace oslog,
    subpartition P_20150529 values ('20150529') tablespace oslog,
    subpartition P_20150530 values ('20150530') tablespace oslog,
    subpartition P_20150531 values ('20150531') tablespace oslog,
    subpartition P_20150601 values ('20150601') tablespace oslog,
    subpartition P_20150602 values ('20150602') tablespace oslog,
    subpartition P_20150603 values ('20150603') tablespace oslog,
    subpartition P_20150604 values ('20150604') tablespace oslog,
    subpartition P_20150605 values ('20150605') tablespace oslog,
    subpartition P_20150606 values ('20150606') tablespace oslog,
    subpartition P_20150607 values ('20150607') tablespace oslog,
    subpartition P_20150608 values ('20150608') tablespace oslog,
    subpartition P_20150609 values ('20150609') tablespace oslog,
    subpartition P_20150610 values ('20150610') tablespace oslog,
    subpartition P_20150611 values ('20150611') tablespace oslog,
    subpartition P_20150612 values ('20150612') tablespace oslog,
    subpartition P_20150613 values ('20150613') tablespace oslog,
    subpartition P_20150614 values ('20150614') tablespace oslog,
    subpartition P_20150615 values ('20150615') tablespace oslog,
    subpartition P_20150616 values ('20150616') tablespace oslog,
    subpartition P_20150617 values ('20150617') tablespace oslog,
    subpartition P_20150618 values ('20150618') tablespace oslog,
    subpartition P_20150619 values ('20150619') tablespace oslog,
    subpartition P_20150620 values ('20150620') tablespace oslog,
    subpartition P_20150621 values ('20150621') tablespace oslog,
    subpartition P_20150622 values ('20150622') tablespace oslog,
    subpartition P_20150623 values ('20150623') tablespace oslog,
    subpartition P_20150624 values ('20150624') tablespace oslog,
    subpartition P_20150625 values ('20150625') tablespace oslog,
    subpartition P_20150626 values ('20150626') tablespace oslog,
    subpartition P_20150627 values ('20150627') tablespace oslog,
    subpartition P_20150628 values ('20150628') tablespace oslog,
    subpartition P_20150629 values ('20150629') tablespace oslog,
    subpartition P_20150630 values ('20150630') tablespace oslog,
    subpartition P_20150701 values ('20150701') tablespace oslog,
    subpartition P_20150702 values ('20150702') tablespace oslog,
    subpartition P_20150703 values ('20150703') tablespace oslog,
    subpartition P_20150704 values ('20150704') tablespace oslog,
    subpartition P_20150705 values ('20150705') tablespace oslog,
    subpartition P_20150706 values ('20150706') tablespace oslog,
    subpartition P_20150707 values ('20150707') tablespace oslog,
    subpartition P_20150708 values ('20150708') tablespace oslog,
    subpartition P_20150709 values ('20150709') tablespace oslog,
    subpartition P_20150710 values ('20150710') tablespace oslog,
    subpartition P_20150711 values ('20150711') tablespace oslog,
    subpartition P_20150712 values ('20150712') tablespace oslog,
    subpartition P_20150713 values ('20150713') tablespace oslog,
    subpartition P_20150714 values ('20150714') tablespace oslog,
    subpartition P_20150715 values ('20150715') tablespace oslog,
    subpartition P_20150716 values ('20150716') tablespace oslog,
    subpartition P_20150717 values ('20150717') tablespace oslog,
    subpartition P_20150718 values ('20150718') tablespace oslog,
    subpartition P_20150719 values ('20150719') tablespace oslog,
    subpartition P_20150720 values ('20150720') tablespace oslog,
    subpartition P_20150721 values ('20150721') tablespace oslog,
    subpartition P_20150722 values ('20150722') tablespace oslog,
    subpartition P_20150723 values ('20150723') tablespace oslog,
    subpartition P_20150724 values ('20150724') tablespace oslog,
    subpartition P_20150725 values ('20150725') tablespace oslog,
    subpartition P_20150726 values ('20150726') tablespace oslog,
    subpartition P_20150727 values ('20150727') tablespace oslog,
    subpartition P_20150728 values ('20150728') tablespace oslog,
    subpartition P_20150729 values ('20150729') tablespace oslog,
    subpartition P_20150730 values ('20150730') tablespace oslog,
    subpartition P_20150731 values ('20150731') tablespace oslog,
    subpartition P_20150801 values ('20150801') tablespace oslog,
    subpartition P_20150802 values ('20150802') tablespace oslog,
    subpartition P_20150803 values ('20150803') tablespace oslog,
    subpartition P_20150804 values ('20150804') tablespace oslog,
    subpartition P_20150805 values ('20150805') tablespace oslog,
    subpartition P_20150806 values ('20150806') tablespace oslog,
    subpartition P_20150807 values ('20150807') tablespace oslog,
    subpartition P_20150808 values ('20150808') tablespace oslog,
    subpartition P_20150809 values ('20150809') tablespace oslog,
    subpartition P_20150810 values ('20150810') tablespace oslog,
    subpartition P_20150811 values ('20150811') tablespace oslog,
    subpartition P_20150812 values ('20150812') tablespace oslog,
    subpartition P_20150813 values ('20150813') tablespace oslog,
    subpartition P_20150814 values ('20150814') tablespace oslog,
    subpartition P_20150815 values ('20150815') tablespace oslog,
    subpartition P_20150816 values ('20150816') tablespace oslog,
    subpartition P_20150817 values ('20150817') tablespace oslog,
    subpartition P_20150818 values ('20150818') tablespace oslog,
    subpartition P_20150819 values ('20150819') tablespace oslog,
    subpartition P_20150820 values ('20150820') tablespace oslog,
    subpartition P_20150821 values ('20150821') tablespace oslog,
    subpartition P_20150822 values ('20150822') tablespace oslog,
    subpartition P_20150823 values ('20150823') tablespace oslog,
    subpartition P_20150824 values ('20150824') tablespace oslog,
    subpartition P_20150825 values ('20150825') tablespace oslog,
    subpartition P_20150826 values ('20150826') tablespace oslog,
    subpartition P_20150827 values ('20150827') tablespace oslog,
    subpartition P_20150828 values ('20150828') tablespace oslog,
    subpartition P_20150829 values ('20150829') tablespace oslog,
    subpartition P_20150830 values ('20150830') tablespace oslog,
    subpartition P_20150831 values ('20150831') tablespace oslog,
    subpartition P_20150901 values ('20150901') tablespace oslog,
    subpartition P_20150902 values ('20150902') tablespace oslog,
    subpartition P_20150903 values ('20150903') tablespace oslog,
    subpartition P_20150904 values ('20150904') tablespace oslog,
    subpartition P_20150905 values ('20150905') tablespace oslog,
    subpartition P_20150906 values ('20150906') tablespace oslog,
    subpartition P_20150907 values ('20150907') tablespace oslog,
    subpartition P_20150908 values ('20150908') tablespace oslog,
    subpartition P_20150909 values ('20150909') tablespace oslog,
    subpartition P_20150910 values ('20150910') tablespace oslog,
    subpartition P_20150911 values ('20150911') tablespace oslog,
    subpartition P_20150912 values ('20150912') tablespace oslog,
    subpartition P_20150913 values ('20150913') tablespace oslog,
    subpartition P_20150914 values ('20150914') tablespace oslog,
    subpartition P_20150915 values ('20150915') tablespace oslog,
    subpartition P_20150916 values ('20150916') tablespace oslog,
    subpartition P_20150917 values ('20150917') tablespace oslog,
    subpartition P_20150918 values ('20150918') tablespace oslog,
    subpartition P_20150919 values ('20150919') tablespace oslog,
    subpartition P_20150920 values ('20150920') tablespace oslog,
    subpartition P_20150921 values ('20150921') tablespace oslog,
    subpartition P_20150922 values ('20150922') tablespace oslog,
    subpartition P_20150923 values ('20150923') tablespace oslog,
    subpartition P_20150924 values ('20150924') tablespace oslog,
    subpartition P_20150925 values ('20150925') tablespace oslog,
    subpartition P_20150926 values ('20150926') tablespace oslog,
    subpartition P_20150927 values ('20150927') tablespace oslog,
    subpartition P_20150928 values ('20150928') tablespace oslog,
    subpartition P_20150929 values ('20150929') tablespace oslog,
    subpartition P_20150930 values ('20150930') tablespace oslog,
    subpartition P_20151001 values ('20151001') tablespace oslog,
    subpartition P_20151002 values ('20151002') tablespace oslog,
    subpartition P_20151003 values ('20151003') tablespace oslog,
    subpartition P_20151004 values ('20151004') tablespace oslog,
    subpartition P_20151005 values ('20151005') tablespace oslog,
    subpartition P_20151006 values ('20151006') tablespace oslog,
    subpartition P_20151007 values ('20151007') tablespace oslog,
    subpartition P_20151008 values ('20151008') tablespace oslog,
    subpartition P_20151009 values ('20151009') tablespace oslog,
    subpartition P_20151010 values ('20151010') tablespace oslog,
    subpartition P_20151011 values ('20151011') tablespace oslog,
    subpartition P_20151012 values ('20151012') tablespace oslog,
    subpartition P_20151013 values ('20151013') tablespace oslog,
    subpartition P_20151014 values ('20151014') tablespace oslog,
    subpartition P_20151015 values ('20151015') tablespace oslog,
    subpartition P_20151016 values ('20151016') tablespace oslog,
    subpartition P_20151017 values ('20151017') tablespace oslog,
    subpartition P_20151018 values ('20151018') tablespace oslog,
    subpartition P_20151019 values ('20151019') tablespace oslog,
    subpartition P_20151020 values ('20151020') tablespace oslog,
    subpartition P_20151021 values ('20151021') tablespace oslog,
    subpartition P_20151022 values ('20151022') tablespace oslog,
    subpartition P_20151023 values ('20151023') tablespace oslog,
    subpartition P_20151024 values ('20151024') tablespace oslog,
    subpartition P_20151025 values ('20151025') tablespace oslog,
    subpartition P_20151026 values ('20151026') tablespace oslog,
    subpartition P_20151027 values ('20151027') tablespace oslog,
    subpartition P_20151028 values ('20151028') tablespace oslog,
    subpartition P_20151029 values ('20151029') tablespace oslog,
    subpartition P_20151030 values ('20151030') tablespace oslog,
    subpartition P_20151031 values ('20151031') tablespace oslog,
    subpartition P_20151101 values ('20151101') tablespace oslog,
    subpartition P_20151102 values ('20151102') tablespace oslog,
    subpartition P_20151103 values ('20151103') tablespace oslog,
    subpartition P_20151104 values ('20151104') tablespace oslog,
    subpartition P_20151105 values ('20151105') tablespace oslog,
    subpartition P_20151106 values ('20151106') tablespace oslog,
    subpartition P_20151107 values ('20151107') tablespace oslog,
    subpartition P_20151108 values ('20151108') tablespace oslog,
    subpartition P_20151109 values ('20151109') tablespace oslog,
    subpartition P_20151110 values ('20151110') tablespace oslog,
    subpartition P_20151111 values ('20151111') tablespace oslog,
    subpartition P_20151112 values ('20151112') tablespace oslog,
    subpartition P_20151113 values ('20151113') tablespace oslog,
    subpartition P_20151114 values ('20151114') tablespace oslog,
    subpartition P_20151115 values ('20151115') tablespace oslog,
    subpartition P_20151116 values ('20151116') tablespace oslog,
    subpartition P_20151117 values ('20151117') tablespace oslog,
    subpartition P_20151118 values ('20151118') tablespace oslog,
    subpartition P_20151119 values ('20151119') tablespace oslog,
    subpartition P_20151120 values ('20151120') tablespace oslog,
    subpartition P_20151121 values ('20151121') tablespace oslog,
    subpartition P_20151122 values ('20151122') tablespace oslog,
    subpartition P_20151123 values ('20151123') tablespace oslog,
    subpartition P_20151124 values ('20151124') tablespace oslog,
    subpartition P_20151125 values ('20151125') tablespace oslog,
    subpartition P_20151126 values ('20151126') tablespace oslog,
    subpartition P_20151127 values ('20151127') tablespace oslog,
    subpartition P_20151128 values ('20151128') tablespace oslog,
    subpartition P_20151129 values ('20151129') tablespace oslog,
    subpartition P_20151130 values ('20151130') tablespace oslog,
    subpartition P_20151201 values ('20151201') tablespace oslog,
    subpartition P_20151202 values ('20151202') tablespace oslog,
    subpartition P_20151203 values ('20151203') tablespace oslog,
    subpartition P_20151204 values ('20151204') tablespace oslog,
    subpartition P_20151205 values ('20151205') tablespace oslog,
    subpartition P_20151206 values ('20151206') tablespace oslog,
    subpartition P_20151207 values ('20151207') tablespace oslog,
    subpartition P_20151208 values ('20151208') tablespace oslog,
    subpartition P_20151209 values ('20151209') tablespace oslog,
    subpartition P_20151210 values ('20151210') tablespace oslog,
    subpartition P_20151211 values ('20151211') tablespace oslog,
    subpartition P_20151212 values ('20151212') tablespace oslog,
    subpartition P_20151213 values ('20151213') tablespace oslog,
    subpartition P_20151214 values ('20151214') tablespace oslog,
    subpartition P_20151215 values ('20151215') tablespace oslog,
    subpartition P_20151216 values ('20151216') tablespace oslog,
    subpartition P_20151217 values ('20151217') tablespace oslog,
    subpartition P_20151218 values ('20151218') tablespace oslog,
    subpartition P_20151219 values ('20151219') tablespace oslog,
    subpartition P_20151220 values ('20151220') tablespace oslog,
    subpartition P_20151221 values ('20151221') tablespace oslog,
    subpartition P_20151222 values ('20151222') tablespace oslog,
    subpartition P_20151223 values ('20151223') tablespace oslog,
    subpartition P_20151224 values ('20151224') tablespace oslog,
    subpartition P_20151225 values ('20151225') tablespace oslog,
    subpartition P_20151226 values ('20151226') tablespace oslog,
    subpartition P_20151227 values ('20151227') tablespace oslog,
    subpartition P_20151228 values ('20151228') tablespace oslog,
    subpartition P_20151229 values ('20151229') tablespace oslog,
    subpartition P_20151230 values ('20151230') tablespace oslog,
    subpartition P_20151231 values ('20151231') tablespace oslog,
subpartition p_default  values (default) tablespace oslog
)
(
  partition P_1 values ('day')    tablespace oslog,
  partition P_2 values ('month')  tablespace oslog ,
  partition P_3 values ('week') tablespace oslog,
  partition P_4 values ('time') tablespace oslog ,
  partition PDEFAULT values (default) tablespace oslog
);


--查看分区的信息及表里面的数据信息


select * from user_part_tables where table_name ='TB_USS_JOB_DATA_PART';
select domain_name,count(*)  from TB_USS_JOB_test group by domain_name ;

select count(*) from TB_USS_JOB_test partition (p_1);


alter table TB_USS_JOB_DATA_PART exchange partition p_1 with table TB_USS_JOB_TEST  without validation;




0 0
尼古丁 知乎 尼古丁 知乎
原创粉丝点击
热门IT博客
歼十c的性能数据歼十c的性能数据
淘宝拒收快递运费谁出淘宝拒收快递运费谁出
长江航运 知乎
数据库scheme
云南白药气雾剂 知乎
9.9元天天特价淘宝童装
linux 红底白字
linux内网建站
新浪网络经纪人
学数据库有什么用知乎
电脑热点分享软件
淘宝3c认证怎么填写
清朝北京城 知乎
伯恩茅斯大学 知乎
北卡大学淘宝真的假的
环保部数据库
suse linux进入命令行
网络异常故障排除
国家电网办公软件大全
mac 修复flash 插件
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 少匪追夫之和尚你还俗吗 水晶鞋匪我思存 星光璀璨匪我思存 双成匪我思存 宫学有匪 有匪番外 香寒匪我思存 江北女匪 有匪君子 匪我思存作品集 少匪追夫和尚你还俗吗 有匪主要讲什么 桃花依旧笑春风匪我思存 有匪每个人结局 匪帅 银行匪帮 匪帮说唱 匪帮说唱传奇 银行匪帮免费版 匪徒 匪徒的拼音 山野匪患 匪患by公子欢喜 两个女匪王 民国匪王 乱世匪王 匪王 两个女匪王1至32集免费看 悍匪之王 天怒1931之两个女匪王 天怒1931两个女匪王 铃木盗匪 盗匪长剑 骑马与砍杀之盗匪生涯 我有很多标签 匪盗 匪警电话 匪警 匪警是什么意思 匮 中匮 匮怎么读

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里