|
[oracle@dwhtest bin]$ cat 1.sh
date=`echo $1 | tr -d '-'`
date1=`echo $2 | tr -d '-'`
date2=`echo $1`
date_end=`get_date $2 +1 | tr -d '-'`
while :
do
echo "partition p$date values less than (to_date('$date2','yyyy-mm-dd')),"
date2=`get_date $date +1`
date=`echo $date2 | tr -d '-'`
if [ $date = $date_end ]
then
exit
fi
done
[oracle@dwhtest bin]$ cat get_date
echo " set colsep |;
set echo off;
set feedback off;
set heading off;
set pagesize 0;
set termout off;
set trimout on;
set trimspool on;
set linesize 3000;
spool ./date.txt1;
select (to_date('$1')$2) from dual where rownum=1;
spool off;
" | sqlplus dwm/dwm >/dev/null
if [ -f ./date.txt1 ]
then
cat ./date.txt1 | grep -v "^SQL>" | tr -d ' ' >./date.txt
rm -f ./date.txt1
else
echo "È¡±íÃû×Ö´íÎó"
exit
fi
date=`cat ./date.txt`
rm -f ./date.txt
echo $date
-------------------------------------------------------------------------
create table DWF.P_F_AGT_BUSINESS_CONTRACT_H
(
AGMT_ID VARCHAR2(40) not null,
AGMT_MOD_CD VARCHAR2(10) not null,
START_DT DATE not null,
CORP_ORG VARCHAR2(10) not null,
RELATIVESERIALNO VARCHAR2(32),
ARTIFICIALNO VARCHAR2(32),
OCCURDATE DATE,
CUST_NO VARCHAR2(32),
CUST_NAME VARCHAR2(80),
BUSINESSTYPE VARCHAR2(18),
OLD_BUSINESS_TYPE VARCHAR2(18),
BUSINESSSUBTYPE VARCHAR2(18),
OCCURTYPE VARCHAR2(18),
CREDITDIGEST VARCHAR2(18),
CREDITCYCLE VARCHAR2(18),
CREDITTYPE VARCHAR2(18),
CURRENYLIST VARCHAR2(18),
RATE_ENCY_MODE VARCHAR2(18),
BUSINESSTYPELIST VARCHAR2(18),
CALCULATEMODE VARCHAR2(18),
USEORGLIST VARCHAR2(18),
FLOWREDUCEFLAG VARCHAR2(18),
CONTRACTFLAG VARCHAR2(18),
SUBCONTRACTFLAG VARCHAR2(18),
SELFUSEFLAG VARCHAR2(18),
CREDITINDEX NUMBER(10,6),
CREDITREDUCESUM NUMBER(24,6),
LIMITATIONTERM DATE,
USETERM DATE,
CREDITAGGREEMENT VARCHAR2(32),
RELATIVEAGREEMENT VARCHAR2(32),
LOANFLAG VARCHAR2(18),
TOTALSUM NUMBER(24,6),
OURROLE VARCHAR2(18),
REVERSIBILITY VARCHAR2(18),
BILL_COUNT INTEGER,
HOUSETYPE VARCHAR2(18),
LC_TERM_TYPE VARCHAR2(18),
RISKATTRIBUTE VARCHAR2(18),
SURETYPE VARCHAR2(18),
SAFEGUARDTYPE VARCHAR2(18),
CREDITBUSINESS VARCHAR2(18),
CUR_CD VARCHAR2(18),
AMT NUMBER(24,6),
BUSINESSPROP NUMBER(10,6),
TERMYEAR INTEGER,
TERMMONTH INTEGER,
TERMDAY INTEGER,
LGTERM VARCHAR2(10),
BASE_RATE_TYPE VARCHAR2(18),
BASE_RATE NUMBER(10,6),
RATEFLOATTYPE VARCHAR2(18),
RATEFLOAT NUMBER(10,6),
RATE NUMBER(10,6),
FEE_TYPE VARCHAR2(18),
FEE_ACCT_PERIOD2 VARCHAR2(18),
CHARGE_RATE NUMBER(10,6),
FEE_AMT NUMBER(24,6),
LC_TERM_TYPE2 VARCHAR2(40),
FEE_ACCT_PERIOD VARCHAR2(18),
PROMISESFEERATIO NUMBER(10,6),
PROMISESFEESUM NUMBER(24,6),
PROMISESFEEPERIOD INTEGER,
PROMISESFEEBEGIN DATE,
MANAGER_FEE_RATIO NUMBER(10,6),
MANAGER_FEE_SUM NUMBER(24,6),
PAYMENTTYPE VARCHAR2(18),
AGENCY_FEE NUMBER(24,6),
DEALFEE NUMBER(24,6),
TOTALCAST NUMBER(24,6),
DIS_INT NUMBER(24,6),
PURCHASERINTEREST NUMBER(24,6),
BARGAINORINTEREST NUMBER(24,6),
SETTLE_AMT NUMBER(24,6),
BAIL_RATIO NUMBER(10,6),
BAIL_CUR_CODE VARCHAR2(18),
BAIL_AMT NUMBER(24,6),
BAIL_ACCT_NO VARCHAR2(32),
FINERATETYPE VARCHAR2(18),
FINERATE NUMBER(10,6),
DRAWINGTYPE VARCHAR2(18),
FIRSTDRAWINGDATE DATE,
DRAWINGPERIOD INTEGER,
REPAY_TIMES INTEGER,
PAYCYC VARCHAR2(18),
GRACEPERIOD INTEGER,
OVERDRAFTPERIOD INTEGER,
O_LD_NO VARCHAR2(32),
O_LC_TERM_TYPE VARCHAR2(18),
O_LC_CURRENCY VARCHAR2(18),
O_LD_SUM NUMBER(24,6),
O_LC_LOADING_DATE VARCHAR2(30),
O_LC_VALID_DATE VARCHAR2(10),
DIRECTION VARCHAR2(18),
PURPOSE VARCHAR2(200),
PLANALLOCATION VARCHAR2(200),
IMMEDIACYPAYSOURCE VARCHAR2(200),
REPAY_SOURCE VARCHAR2(200),
CORPUSPAYMETHOD VARCHAR2(18),
INTERESTPAYMETHOD VARCHAR2(18),
PUTOUTDATE DATE,
MATURITY_DT VARCHAR2(10),
THIRDPARTY1 VARCHAR2(200),
THIRDPARTYID1 VARCHAR2(200),
THIRDPARTY2 VARCHAR2(200),
THIRDPARTYID2 VARCHAR2(32),
THIRDPARTY3 VARCHAR2(200),
THIRDPARTYID3 VARCHAR2(32),
THIRDPARTYREGION VARCHAR2(18),
THIRDPARTYACCOUNTS VARCHAR2(32),
BALE_NAME VARCHAR2(80),
PROJECTNAME VARCHAR2(80),
CONTEXTINFO VARCHAR2(100),
SECURITIESTYPE VARCHAR2(200),
SECURITIESREGION VARCHAR2(18),
CONSTRUCTIONAREA NUMBER(24,6),
USEAREA NUMBER(24,6),
FLAG1 VARCHAR2(18),
FLAG2 VARCHAR2(18),
FLAG3 VARCHAR2(18),
TRADECONTRACTNO VARCHAR2(32),
INVOICE_NO VARCHAR2(200),
TRADECURRENCY VARCHAR2(18),
TRADESUM NUMBER(24,6),
LC_NO VARCHAR2(32),
PAYMENTDATE DATE,
OPERATIONMODE VARCHAR2(18),
START_DATE DATE,
MATURITY_DATE DATE,
VOUCHCLASS VARCHAR2(18),
VOUCHTYPE VARCHAR2(18),
GUARANTYTYPE1 VARCHAR2(18),
GUARANTYTYPE2 VARCHAR2(18),
VOUCHFLAG VARCHAR2(18),
WARRANTOR VARCHAR2(80),
WARRANTORID VARCHAR2(32),
GUARANTYVALUE NUMBER(24,6),
GUARANTYRATE NUMBER(10,6),
BASEEVALUATERESULT VARCHAR2(18),
RISKRATE NUMBER(24,6),
LOWRISK VARCHAR2(18),
OTHERAREALOAN VARCHAR2(18),
LOWRISKBAILSUM NUMBER(24,6),
APPLYTYPE VARCHAR2(18),
ORIGINALPUTOUTDATE DATE,
EXTENDTIMES INTEGER,
RENEWTIMES INTEGER,
GOLNTIMES INTEGER,
REORG_TIMES INTEGER,
GUARANTYNO VARCHAR2(32),
PUTOUTSUM NUMBER(24,6),
ACTUALPUTOUTSUM NUMBER(24,6),
TDAY_BAL NUMBER(24,6),
NOR_BAL NUMBER(24,6),
OVERDUE_BAL NUMBER(24,6),
DULLBALANCE NUMBER(24,6),
BADBALANCE NUMBER(24,6),
INTERESTBALANCE1 NUMBER(24,6),
INTERESTBALANCE2 NUMBER(24,6),
FINEBALANCE1 NUMBER(24,6),
FINEBALANCE2 NUMBER(24,6),
OVERDUE_DAYS INTEGER,
OWEINTERESTDAYS INTEGER,
TABALANCE NUMBER(24,6),
TAINTERESTBALANCE NUMBER(24,6),
TATIMES INTEGER,
LCATIMES NUMBER(24,6),
PBINTERESTSUM NUMBER(24,6),
PBCBSEESUM NUMBER(24,6),
PBPDGSUM NUMBER(24,6),
PBLEGALCOSTSUM NUMBER(24,6),
POLEGALCOSTSUM NUMBER(24,6),
ORIGINALBADDATE DATE,
BASECLASSIFYRESULT VARCHAR2(18),
CLASSIFYRESULT VARCHAR2(80),
CLASSIFYTYPE VARCHAR2(18),
CLASSIFYDATE DATE,
CLASSIFYORGID VARCHAR2(32),
RESERVESUM NUMBER(24,6),
EXPECTLOSSSUM NUMBER(24,6),
BAILRATE NUMBER(24,6),
FINISHORG VARCHAR2(18),
FINISHTYPE VARCHAR2(18),
FINISHDATE DATE,
DESCRIBE1 VARCHAR2(2000),
REINFORCEFLAG VARCHAR2(18),
MANAGEORGID VARCHAR2(32),
MANAGEUSERID VARCHAR2(32),
RECOVERYORGID VARCHAR2(32),
RECOVERYUSERID VARCHAR2(32),
STATORGID VARCHAR2(32),
STATUSERID VARCHAR2(32),
OPERATE_ORG VARCHAR2(32),
OPERATE_PERSON VARCHAR2(32),
OPERATE_DATE DATE,
INPUT_ORG VARCHAR2(32),
INPUTUSERID VARCHAR2(32),
REG_DATE DATE,
UPDATE_DATE DATE,
PIGEONHOLE_DATE DATE,
REMARK VARCHAR2(200),
FLAG4 VARCHAR2(18),
PAYCURRENCY VARCHAR2(18),
PAY_DATE DATE,
FLAG5 VARCHAR2(18),
CLASSIFYSUM1 NUMBER(24,6),
CLASSIFYSUM2 NUMBER(24,6),
CLASSIFYSUM3 NUMBER(24,6),
CLASSIFYSUM4 NUMBER(24,6),
CLASSIFYSUM5 NUMBER(24,6),
SHIFTTYPE VARCHAR2(18),
OPERATETYPE VARCHAR2(18),
FUND_SRC VARCHAR2(18),
CYCLEFLAG VARCHAR2(18),
CREDITFREEZEFLAG VARCHAR2(18),
SHIFTBALANCE NUMBER(24,6),
CLASSIFYFREQUENCY INTEGER,
CLASSIFYLEVEL VARCHAR2(18),
VOUCHNEWFLAG VARCHAR2(18),
ACTUALARTIFICIALNO VARCHAR2(32),
DELETEFLAG VARCHAR2(18),
SETTLE_ACCT_NO VARCHAR2(32),
LOANACCOUNTNO VARCHAR2(32),
SECONDPAYACCOUNT VARCHAR2(32),
ADJUSTRATETYPE VARCHAR2(18),
ADJUSTRATETERM VARCHAR2(18),
OVERINTTYPE VARCHAR2(18),
RATEADJUSTCYC VARCHAR2(18),
PDGACCOUNTNO VARCHAR2(32),
DECUCT_DATE DATE,
FZANBALANCE NUMBER(24,6),
ACCEPTINTTYPE VARCHAR2(18),
RATIO NUMBER(24,6),
THIRDPARTYADD1 VARCHAR2(80),
THIRDPARTYZIP1 VARCHAR2(32),
THIRDPARTYADD2 VARCHAR2(80),
THIRDPARTYZIP2 VARCHAR2(32),
THIRDPARTYADD3 VARCHAR2(80),
THIRDPARTYZIP3 VARCHAR2(32),
LC_EFFECT_AREA VARCHAR2(18),
TERMDATE1 DATE,
PRESENTPERIOD DATE,
TERM_DATE DATE,
FIXCYC INTEGER,
DESCRIBE2 VARCHAR2(100),
CAN_AMT NUMBER(24,6),
CAN_INT NUMBER(24,6),
TERM VARCHAR2(18),
DEAL_ORG VARCHAR2(32),
TEMPSAVEFLAG VARCHAR2(18),
OVERDUE_DATE DATE,
OWEINTERESTDATE DATE,
FREEZE_FLAG VARCHAR2(1),
APPROVEDATE DATE,
SHIFTSTATUS VARCHAR2(18),
RECOVERYCOGNORGID VARCHAR2(32),
RECOVERYCOGNUSERID VARCHAR2(32),
SHIFTDOCDESCRIBE VARCHAR2(800),
APPLY_DATE VARCHAR2(10),
REPAY_DATE VARCHAR2(10),
REPAYFUNDSOURCE VARCHAR2(200),
ACCUM_IN_OUT VARCHAR2(18),
LOWRISKSUM NUMBER(24,6),
SETTLE_DATE DATE,
BSFLIMIT VARCHAR2(10),
BSFRISKSTATE VARCHAR2(10),
HEAPBALANCE NUMBER(24,6),
BREAKDATE DATE,
BILLTYPE VARCHAR2(20),
PRODUCT_NO VARCHAR2(32),
ISDIVIDED VARCHAR2(20),
RELATIVECONTRACTNO VARCHAR2(32),
COOPERATIVECLNO VARCHAR2(32),
COOPERATIVECLTYPE VARCHAR2(18),
GUARANTEESUM NUMBER(22,6),
CREDITSUM NUMBER(22,6),
PAWNSUM NUMBER(22,6),
PAY_INT_INTVL NUMBER,
INTMODE VARCHAR2(1),
OTHERAREALOAN2 VARCHAR2(18),
PRODUCT_NO2 VARCHAR2(32),
TAXLISTORNOT VARCHAR2(32),
CREDITDEPOSITORYSUM NUMBER(24,6),
END_DT DATE,
DW_DATA_DT DATE,
CONTRACT_STATUS VARCHAR2(20),
AUDIT_USER_ID VARCHAR2(32),
LISTINSUM NUMBER(24,6),
TEXTNO VARCHAR2(40),
USD_CONV_RATE NUMBER(24,6)
) partition by range (END_DT)
(partition p20110101 values less than (to_date('2011-01-01','yyyy-mm-dd')),
partition p20110102 values less than (to_date('2011-01-02','yyyy-mm-dd')),
partition p20110103 values less than (to_date('2011-01-03','yyyy-mm-dd')),
partition p20110104 values less than (to_date('2011-01-04','yyyy-mm-dd')),
partition p20110105 values less than (to_date('2011-01-05','yyyy-mm-dd')),
partition p20110106 values less than (to_date('2011-01-06','yyyy-mm-dd')),
partition p20110107 values less than (to_date('2011-01-07','yyyy-mm-dd')),
partition p20110108 values less than (to_date('2011-01-08','yyyy-mm-dd')),
partition p20110109 values less than (to_date('2011-01-09','yyyy-mm-dd')),
partition p20110110 values less than (to_date('2011-01-10','yyyy-mm-dd')),
partition p20110111 values less than (to_date('2011-01-11','yyyy-mm-dd')),
partition p20110112 values less than (to_date('2011-01-12','yyyy-mm-dd')),
partition p20110113 values less than (to_date('2011-01-13','yyyy-mm-dd')),
partition p20110114 values less than (to_date('2011-01-14','yyyy-mm-dd')),
partition p20110115 values less than (to_date('2011-01-15','yyyy-mm-dd')),
partition p20110116 values less than (to_date('2011-01-16','yyyy-mm-dd')),
partition p20110117 values less than (to_date('2011-01-17','yyyy-mm-dd')),
partition p20110118 values less than (to_date('2011-01-18','yyyy-mm-dd')),
partition p20110119 values less than (to_date('2011-01-19','yyyy-mm-dd')),
partition p20110120 values less than (to_date('2011-01-20','yyyy-mm-dd')),
partition p20110121 values less than (to_date('2011-01-21','yyyy-mm-dd')),
partition p20110122 values less than (to_date('2011-01-22','yyyy-mm-dd')),
partition p20110123 values less than (to_date('2011-01-23','yyyy-mm-dd')),
partition p20110124 values less than (to_date('2011-01-24','yyyy-mm-dd')),
partition p20110125 values less than (to_date('2011-01-25','yyyy-mm-dd')),
partition p20110126 values less than (to_date('2011-01-26','yyyy-mm-dd')),
partition p20110127 values less than (to_date('2011-01-27','yyyy-mm-dd')),
partition p20110128 values less than (to_date('2011-01-28','yyyy-mm-dd')),
partition p20110129 values less than (to_date('2011-01-29','yyyy-mm-dd')),
partition p20110130 values less than (to_date('2011-01-30','yyyy-mm-dd')),
partition p20110131 values less than (to_date('2011-01-31','yyyy-mm-dd')),
partition p20110201 values less than (to_date('2011-02-01','yyyy-mm-dd')),
partition p20110202 values less than (to_date('2011-02-02','yyyy-mm-dd')),
partition p20110203 values less than (to_date('2011-02-03','yyyy-mm-dd')),
partition p20110204 values less than (to_date('2011-02-04','yyyy-mm-dd')),
partition p20110205 values less than (to_date('2011-02-05','yyyy-mm-dd')),
partition p20110206 values less than (to_date('2011-02-06','yyyy-mm-dd')),
partition p20110207 values less than (to_date('2011-02-07','yyyy-mm-dd')),
partition p20110208 values less than (to_date('2011-02-08','yyyy-mm-dd')),
partition p20110209 values less than (to_date('2011-02-09','yyyy-mm-dd')),
partition p20110210 values less than (to_date('2011-02-10','yyyy-mm-dd')),
partition p20110211 values less than (to_date('2011-02-11','yyyy-mm-dd')),
partition p20110212 values less than (to_date('2011-02-12','yyyy-mm-dd')),
partition p20110213 values less than (to_date('2011-02-13','yyyy-mm-dd')),
partition p20110214 values less than (to_date('2011-02-14','yyyy-mm-dd')),
partition p20110215 values less than (to_date('2011-02-15','yyyy-mm-dd')),
partition p20110216 values less than (to_date('2011-02-16','yyyy-mm-dd')),
partition p20110217 values less than (to_date('2011-02-17','yyyy-mm-dd')),
partition p20110218 values less than (to_date('2011-02-18','yyyy-mm-dd')),
partition p20110219 values less than (to_date('2011-02-19','yyyy-mm-dd')),
partition p20110220 values less than (to_date('2011-02-20','yyyy-mm-dd')),
partition p20110221 values less than (to_date('2011-02-21','yyyy-mm-dd')),
partition p20110222 values less than (to_date('2011-02-22','yyyy-mm-dd')),
partition p20110223 values less than (to_date('2011-02-23','yyyy-mm-dd')),
partition p20110224 values less than (to_date('2011-02-24','yyyy-mm-dd')),
partition p20110225 values less than (to_date('2011-02-25','yyyy-mm-dd')),
partition p20110226 values less than (to_date('2011-02-26','yyyy-mm-dd')),
partition p20110227 values less than (to_date('2011-02-27','yyyy-mm-dd')),
partition p20110228 values less than (to_date('2011-02-28','yyyy-mm-dd')),
partition p20110301 values less than (to_date('2011-03-01','yyyy-mm-dd')),
partition p20110302 values less than (to_date('2011-03-02','yyyy-mm-dd')),
partition p20110303 values less than (to_date('2011-03-03','yyyy-mm-dd')),
partition p20110304 values less than (to_date('2011-03-04','yyyy-mm-dd')),
partition p20110305 values less than (to_date('2011-03-05','yyyy-mm-dd')),
partition p20110306 values less than (to_date('2011-03-06','yyyy-mm-dd')),
partition p20110307 values less than (to_date('2011-03-07','yyyy-mm-dd')),
partition p20110308 values less than (to_date('2011-03-08','yyyy-mm-dd')),
partition p20110309 values less than (to_date('2011-03-09','yyyy-mm-dd')),
partition p20110310 values less than (to_date('2011-03-10','yyyy-mm-dd')),
partition p20110311 values less than (to_date('2011-03-11','yyyy-mm-dd')),
partition p20110312 values less than (to_date('2011-03-12','yyyy-mm-dd')),
partition p20110313 values less than (to_date('2011-03-13','yyyy-mm-dd')),
partition p20110314 values less than (to_date('2011-03-14','yyyy-mm-dd')),
partition p20110315 values less than (to_date('2011-03-15','yyyy-mm-dd')),
partition p20110316 values less than (to_date('2011-03-16','yyyy-mm-dd')),
partition p20110317 values less than (to_date('2011-03-17','yyyy-mm-dd')),
partition p20110318 values less than (to_date('2011-03-18','yyyy-mm-dd')),
partition p20110319 values less than (to_date('2011-03-19','yyyy-mm-dd')),
partition p20110320 values less than (to_date('2011-03-20','yyyy-mm-dd')),
partition p20110321 values less than (to_date('2011-03-21','yyyy-mm-dd')),
partition p20110322 values less than (to_date('2011-03-22','yyyy-mm-dd')),
partition p20110323 values less than (to_date('2011-03-23','yyyy-mm-dd')),
partition p20110324 values less than (to_date('2011-03-24','yyyy-mm-dd')),
partition p20110325 values less than (to_date('2011-03-25','yyyy-mm-dd')),
partition p20110326 values less than (to_date('2011-03-26','yyyy-mm-dd')),
partition p20110327 values less than (to_date('2011-03-27','yyyy-mm-dd')),
partition p20110328 values less than (to_date('2011-03-28','yyyy-mm-dd')),
partition p20110329 values less than (to_date('2011-03-29','yyyy-mm-dd')),
partition p20110330 values less than (to_date('2011-03-30','yyyy-mm-dd')),
partition p20110331 values less than (to_date('2011-03-31','yyyy-mm-dd')),
partition p20110401 values less than (to_date('2011-04-01','yyyy-mm-dd')),
partition p20110402 values less than (to_date('2011-04-02','yyyy-mm-dd')),
partition p20110403 values less than (to_date('2011-04-03','yyyy-mm-dd')),
partition p20110404 values less than (to_date('2011-04-04','yyyy-mm-dd')),
partition p20110405 values less than (to_date('2011-04-05','yyyy-mm-dd')),
partition p20110406 values less than (to_date('2011-04-06','yyyy-mm-dd')),
partition p20110407 values less than (to_date('2011-04-07','yyyy-mm-dd')),
partition p20110408 values less than (to_date('2011-04-08','yyyy-mm-dd')),
partition p20110409 values less than (to_date('2011-04-09','yyyy-mm-dd')),
partition p20110410 values less than (to_date('2011-04-10','yyyy-mm-dd')),
partition p20110411 values less than (to_date('2011-04-11','yyyy-mm-dd')),
partition p20110412 values less than (to_date('2011-04-12','yyyy-mm-dd')),
partition p20110413 values less than (to_date('2011-04-13','yyyy-mm-dd')),
partition p20110414 values less than (to_date('2011-04-14','yyyy-mm-dd')),
partition p20110415 values less than (to_date('2011-04-15','yyyy-mm-dd')),
partition p20110416 values less than (to_date('2011-04-16','yyyy-mm-dd')),
partition p20110417 values less than (to_date('2011-04-17','yyyy-mm-dd')),
partition p20110418 values less than (to_date('2011-04-18','yyyy-mm-dd')),
partition p20110419 values less than (to_date('2011-04-19','yyyy-mm-dd')),
partition p20110420 values less than (to_date('2011-04-20','yyyy-mm-dd')),
partition p20110421 values less than (to_date('2011-04-21','yyyy-mm-dd')),
partition p20110422 values less than (to_date('2011-04-22','yyyy-mm-dd')),
partition p20110423 values less than (to_date('2011-04-23','yyyy-mm-dd')),
partition p20110424 values less than (to_date('2011-04-24','yyyy-mm-dd')),
partition p20110425 values less than (to_date('2011-04-25','yyyy-mm-dd')),
partition p20110426 values less than (to_date('2011-04-26','yyyy-mm-dd')),
partition p20110427 values less than (to_date('2011-04-27','yyyy-mm-dd')),
partition p20110428 values less than (to_date('2011-04-28','yyyy-mm-dd')),
partition p20110429 values less than (to_date('2011-04-29','yyyy-mm-dd')),
partition p20110430 values less than (to_date('2011-04-30','yyyy-mm-dd')),
partition p20110501 values less than (to_date('2011-05-01','yyyy-mm-dd')),
partition p20110502 values less than (to_date('2011-05-02','yyyy-mm-dd')),
partition p20110503 values less than (to_date('2011-05-03','yyyy-mm-dd')),
partition p20110504 values less than (to_date('2011-05-04','yyyy-mm-dd')),
partition p20110505 values less than (to_date('2011-05-05','yyyy-mm-dd')),
partition p20110506 values less than (to_date('2011-05-06','yyyy-mm-dd')),
partition p20110507 values less than (to_date('2011-05-07','yyyy-mm-dd')),
partition p20110508 values less than (to_date('2011-05-08','yyyy-mm-dd')),
partition p20110509 values less than (to_date('2011-05-09','yyyy-mm-dd')),
partition p20110510 values less than (to_date('2011-05-10','yyyy-mm-dd')),
partition p20110511 values less than (to_date('2011-05-11','yyyy-mm-dd')),
partition p20110512 values less than (to_date('2011-05-12','yyyy-mm-dd')),
partition p20110513 values less than (to_date('2011-05-13','yyyy-mm-dd')),
partition p20110514 values less than (to_date('2011-05-14','yyyy-mm-dd')),
partition p20110515 values less than (to_date('2011-05-15','yyyy-mm-dd')),
partition p20110516 values less than (to_date('2011-05-16','yyyy-mm-dd')),
partition p20110517 values less than (to_date('2011-05-17','yyyy-mm-dd')),
partition p20110518 values less than (to_date('2011-05-18','yyyy-mm-dd')),
partition p20110519 values less than (to_date('2011-05-19','yyyy-mm-dd')),
partition p20110520 values less than (to_date('2011-05-20','yyyy-mm-dd')),
partition p20110521 values less than (to_date('2011-05-21','yyyy-mm-dd')),
partition p20110522 values less than (to_date('2011-05-22','yyyy-mm-dd')),
partition p20110523 values less than (to_date('2011-05-23','yyyy-mm-dd')),
partition p20110524 values less than (to_date('2011-05-24','yyyy-mm-dd')),
partition p20110525 values less than (to_date('2011-05-25','yyyy-mm-dd')),
partition p20110526 values less than (to_date('2011-05-26','yyyy-mm-dd')),
partition p20110527 values less than (to_date('2011-05-27','yyyy-mm-dd')),
partition p20110528 values less than (to_date('2011-05-28','yyyy-mm-dd')),
partition p20110529 values less than (to_date('2011-05-29','yyyy-mm-dd')),
partition p20110530 values less than (to_date('2011-05-30','yyyy-mm-dd')),
partition p20110531 values less than (to_date('2011-05-31','yyyy-mm-dd')),
partition p20110601 values less than (to_date('2011-06-01','yyyy-mm-dd')),
partition p20110602 values less than (to_date('2011-06-02','yyyy-mm-dd')),
partition p20110603 values less than (to_date('2011-06-03','yyyy-mm-dd')),
partition p20110604 values less than (to_date('2011-06-04','yyyy-mm-dd')),
partition p20110605 values less than (to_date('2011-06-05','yyyy-mm-dd')),
partition p20110606 values less than (to_date('2011-06-06','yyyy-mm-dd')),
partition p20110607 values less than (to_date('2011-06-07','yyyy-mm-dd')),
partition p20110608 values less than (to_date('2011-06-08','yyyy-mm-dd')),
partition p20110609 values less than (to_date('2011-06-09','yyyy-mm-dd')),
partition p20110610 values less than (to_date('2011-06-10','yyyy-mm-dd')),
partition p20110611 values less than (to_date('2011-06-11','yyyy-mm-dd')),
partition p20110612 values less than (to_date('2011-06-12','yyyy-mm-dd')),
partition p20110613 values less than (to_date('2011-06-13','yyyy-mm-dd')),
partition p20110614 values less than (to_date('2011-06-14','yyyy-mm-dd')),
partition p20110615 values less than (to_date('2011-06-15','yyyy-mm-dd')),
partition p20110616 values less than (to_date('2011-06-16','yyyy-mm-dd')),
partition p20110617 values less than (to_date('2011-06-17','yyyy-mm-dd')),
partition p20110618 values less than (to_date('2011-06-18','yyyy-mm-dd')),
partition p20110619 values less than (to_date('2011-06-19','yyyy-mm-dd')),
partition p20110620 values less than (to_date('2011-06-20','yyyy-mm-dd')),
partition p20110621 values less than (to_date('2011-06-21','yyyy-mm-dd')),
partition p20110622 values less than (to_date('2011-06-22','yyyy-mm-dd')),
partition p20110623 values less than (to_date('2011-06-23','yyyy-mm-dd')),
partition p20110624 values less than (to_date('2011-06-24','yyyy-mm-dd')),
partition p20110625 values less than (to_date('2011-06-25','yyyy-mm-dd')),
partition p20110626 values less than (to_date('2011-06-26','yyyy-mm-dd')),
partition p20110627 values less than (to_date('2011-06-27','yyyy-mm-dd')),
partition p20110628 values less than (to_date('2011-06-28','yyyy-mm-dd')),
partition p20110629 values less than (to_date('2011-06-29','yyyy-mm-dd')),
partition p20110630 values less than (to_date('2011-06-30','yyyy-mm-dd')),
partition p20110701 values less than (to_date('2011-07-01','yyyy-mm-dd')),
partition p20110702 values less than (to_date('2011-07-02','yyyy-mm-dd')),
partition p20110703 values less than (to_date('2011-07-03','yyyy-mm-dd')),
partition p20110704 values less than (to_date('2011-07-04','yyyy-mm-dd')),
partition p20110705 values less than (to_date('2011-07-05','yyyy-mm-dd')),
partition p20110706 values less than (to_date('2011-07-06','yyyy-mm-dd')),
partition p20110707 values less than (to_date('2011-07-07','yyyy-mm-dd')),
partition p20110708 values less than (to_date('2011-07-08','yyyy-mm-dd')),
partition p20110709 values less than (to_date('2011-07-09','yyyy-mm-dd')),
partition p20110710 values less than (to_date('2011-07-10','yyyy-mm-dd')),
partition p20110711 values less than (to_date('2011-07-11','yyyy-mm-dd')),
partition p20110712 values less than (to_date('2011-07-12','yyyy-mm-dd')),
partition p20110713 values less than (to_date('2011-07-13','yyyy-mm-dd')),
partition p20110714 values less than (to_date('2011-07-14','yyyy-mm-dd')),
partition p20110715 values less than (to_date('2011-07-15','yyyy-mm-dd')),
partition p20110716 values less than (to_date('2011-07-16','yyyy-mm-dd')),
partition p20110717 values less than (to_date('2011-07-17','yyyy-mm-dd')),
partition p20110718 values less than (to_date('2011-07-18','yyyy-mm-dd')),
partition p20110719 values less than (to_date('2011-07-19','yyyy-mm-dd')),
partition p20110720 values less than (to_date('2011-07-20','yyyy-mm-dd')),
partition p20110721 values less than (to_date('2011-07-21','yyyy-mm-dd')),
partition p20110722 values less than (to_date('2011-07-22','yyyy-mm-dd')),
partition p20110723 values less than (to_date('2011-07-23','yyyy-mm-dd')),
partition p20110724 values less than (to_date('2011-07-24','yyyy-mm-dd')),
partition p20110725 values less than (to_date('2011-07-25','yyyy-mm-dd')),
partition p20110726 values less than (to_date('2011-07-26','yyyy-mm-dd')),
partition p20110727 values less than (to_date('2011-07-27','yyyy-mm-dd')),
partition p20110728 values less than (to_date('2011-07-28','yyyy-mm-dd')),
partition p20110729 values less than (to_date('2011-07-29','yyyy-mm-dd')),
partition p20110730 values less than (to_date('2011-07-30','yyyy-mm-dd')),
partition p20110731 values less than (to_date('2011-07-31','yyyy-mm-dd')),
partition p20110801 values less than (to_date('2011-08-01','yyyy-mm-dd')),
partition p20110802 values less than (to_date('2011-08-02','yyyy-mm-dd')),
partition p20110803 values less than (to_date('2011-08-03','yyyy-mm-dd')),
partition p20110804 values less than (to_date('2011-08-04','yyyy-mm-dd')),
partition p20110805 values less than (to_date('2011-08-05','yyyy-mm-dd')),
partition p20110806 values less than (to_date('2011-08-06','yyyy-mm-dd')),
partition p20110807 values less than (to_date('2011-08-07','yyyy-mm-dd')),
partition p20110808 values less than (to_date('2011-08-08','yyyy-mm-dd')),
partition p20110809 values less than (to_date('2011-08-09','yyyy-mm-dd')),
partition p20110810 values less than (to_date('2011-08-10','yyyy-mm-dd')),
partition p20110811 values less than (to_date('2011-08-11','yyyy-mm-dd')),
partition p20110812 values less than (to_date('2011-08-12','yyyy-mm-dd')),
partition p20110813 values less than (to_date('2011-08-13','yyyy-mm-dd')),
partition p20110814 values less than (to_date('2011-08-14','yyyy-mm-dd')),
partition p20110815 values less than (to_date('2011-08-15','yyyy-mm-dd')),
partition p20110816 values less than (to_date('2011-08-16','yyyy-mm-dd')),
partition p20110817 values less than (to_date('2011-08-17','yyyy-mm-dd')),
partition p20110818 values less than (to_date('2011-08-18','yyyy-mm-dd')),
partition p20110819 values less than (to_date('2011-08-19','yyyy-mm-dd')),
partition p20110820 values less than (to_date('2011-08-20','yyyy-mm-dd')),
partition p20110821 values less than (to_date('2011-08-21','yyyy-mm-dd')),
partition p20110822 values less than (to_date('2011-08-22','yyyy-mm-dd')),
partition p20110823 values less than (to_date('2011-08-23','yyyy-mm-dd')),
partition p20110824 values less than (to_date('2011-08-24','yyyy-mm-dd')),
partition p20110825 values less than (to_date('2011-08-25','yyyy-mm-dd')),
partition p20110826 values less than (to_date('2011-08-26','yyyy-mm-dd')),
partition p20110827 values less than (to_date('2011-08-27','yyyy-mm-dd')),
partition p20110828 values less than (to_date('2011-08-28','yyyy-mm-dd')),
partition p20110829 values less than (to_date('2011-08-29','yyyy-mm-dd')),
partition p20110830 values less than (to_date('2011-08-30','yyyy-mm-dd')),
partition p20110831 values less than (to_date('2011-08-31','yyyy-mm-dd')),
partition p20110901 values less than (to_date('2011-09-01','yyyy-mm-dd')),
partition p20110902 values less than (to_date('2011-09-02','yyyy-mm-dd')),
partition p20110903 values less than (to_date('2011-09-03','yyyy-mm-dd')),
partition p20110904 values less than (to_date('2011-09-04','yyyy-mm-dd')),
partition p20110905 values less than (to_date('2011-09-05','yyyy-mm-dd')),
partition p20110906 values less than (to_date('2011-09-06','yyyy-mm-dd')),
partition p20110907 values less than (to_date('2011-09-07','yyyy-mm-dd')),
partition p20110908 values less than (to_date('2011-09-08','yyyy-mm-dd')),
partition p20110909 values less than (to_date('2011-09-09','yyyy-mm-dd')),
partition p20110910 values less than (to_date('2011-09-10','yyyy-mm-dd')),
partition p20110911 values less than (to_date('2011-09-11','yyyy-mm-dd')),
partition p20110912 values less than (to_date('2011-09-12','yyyy-mm-dd')),
partition p20110913 values less than (to_date('2011-09-13','yyyy-mm-dd')),
partition p20110914 values less than (to_date('2011-09-14','yyyy-mm-dd')),
partition p20110915 values less than (to_date('2011-09-15','yyyy-mm-dd')),
partition p20110916 values less than (to_date('2011-09-16','yyyy-mm-dd')),
partition p20110917 values less than (to_date('2011-09-17','yyyy-mm-dd')),
partition p20110918 values less than (to_date('2011-09-18','yyyy-mm-dd')),
partition p20110919 values less than (to_date('2011-09-19','yyyy-mm-dd')),
partition p20110920 values less than (to_date('2011-09-20','yyyy-mm-dd')),
partition p20110921 values less than (to_date('2011-09-21','yyyy-mm-dd')),
partition p20110922 values less than (to_date('2011-09-22','yyyy-mm-dd')),
partition p20110923 values less than (to_date('2011-09-23','yyyy-mm-dd')),
partition p20110924 values less than (to_date('2011-09-24','yyyy-mm-dd')),
partition p20110925 values less than (to_date('2011-09-25','yyyy-mm-dd')),
partition p20110926 values less than (to_date('2011-09-26','yyyy-mm-dd')),
partition p20110927 values less than (to_date('2011-09-27','yyyy-mm-dd')),
partition p20110928 values less than (to_date('2011-09-28','yyyy-mm-dd')),
partition p20110929 values less than (to_date('2011-09-29','yyyy-mm-dd')),
partition p20110930 values less than (to_date('2011-09-30','yyyy-mm-dd')),
partition p20111001 values less than (to_date('2011-10-01','yyyy-mm-dd')),
partition p20111002 values less than (to_date('2011-10-02','yyyy-mm-dd')),
partition p20111003 values less than (to_date('2011-10-03','yyyy-mm-dd')),
partition p20111004 values less than (to_date('2011-10-04','yyyy-mm-dd')),
partition p20111005 values less than (to_date('2011-10-05','yyyy-mm-dd')),
partition p20111006 values less than (to_date('2011-10-06','yyyy-mm-dd')),
partition p20111007 values less than (to_date('2011-10-07','yyyy-mm-dd')),
partition p20111008 values less than (to_date('2011-10-08','yyyy-mm-dd')),
partition p20111009 values less than (to_date('2011-10-09','yyyy-mm-dd')),
partition p20111010 values less than (to_date('2011-10-10','yyyy-mm-dd')),
partition p20111011 values less than (to_date('2011-10-11','yyyy-mm-dd')),
partition p20111012 values less than (to_date('2011-10-12','yyyy-mm-dd')),
partition p20111013 values less than (to_date('2011-10-13','yyyy-mm-dd')),
partition p20111014 values less than (to_date('2011-10-14','yyyy-mm-dd')),
partition p20111015 values less than (to_date('2011-10-15','yyyy-mm-dd')),
partition p20111016 values less than (to_date('2011-10-16','yyyy-mm-dd')),
partition p20111017 values less than (to_date('2011-10-17','yyyy-mm-dd')),
partition p20111018 values less than (to_date('2011-10-18','yyyy-mm-dd')),
partition p20111019 values less than (to_date('2011-10-19','yyyy-mm-dd')),
partition p20111020 values less than (to_date('2011-10-20','yyyy-mm-dd')),
partition p20111021 values less than (to_date('2011-10-21','yyyy-mm-dd')),
partition p20111022 values less than (to_date('2011-10-22','yyyy-mm-dd')),
partition p20111023 values less than (to_date('2011-10-23','yyyy-mm-dd')),
partition p20111024 values less than (to_date('2011-10-24','yyyy-mm-dd')),
partition p20111025 values less than (to_date('2011-10-25','yyyy-mm-dd')),
partition p20111026 values less than (to_date('2011-10-26','yyyy-mm-dd')),
partition p20111027 values less than (to_date('2011-10-27','yyyy-mm-dd')),
partition p20111028 values less than (to_date('2011-10-28','yyyy-mm-dd')),
partition p20111029 values less than (to_date('2011-10-29','yyyy-mm-dd')),
partition p20111030 values less than (to_date('2011-10-30','yyyy-mm-dd')),
partition p20111031 values less than (to_date('2011-10-31','yyyy-mm-dd')),
partition p20111101 values less than (to_date('2011-11-01','yyyy-mm-dd')),
partition p20111102 values less than (to_date('2011-11-02','yyyy-mm-dd')),
partition p20111103 values less than (to_date('2011-11-03','yyyy-mm-dd')),
partition p20111104 values less than (to_date('2011-11-04','yyyy-mm-dd')),
partition p20111105 values less than (to_date('2011-11-05','yyyy-mm-dd')),
partition p20111106 values less than (to_date('2011-11-06','yyyy-mm-dd')),
partition p20111107 values less than (to_date('2011-11-07','yyyy-mm-dd')),
partition p20111108 values less than (to_date('2011-11-08','yyyy-mm-dd')),
partition p20111109 values less than (to_date('2011-11-09','yyyy-mm-dd')),
partition p20111110 values less than (to_date('2011-11-10','yyyy-mm-dd')),
partition p20111111 values less than (to_date('2011-11-11','yyyy-mm-dd')),
partition p20111112 values less than (to_date('2011-11-12','yyyy-mm-dd')),
partition p20111113 values less than (to_date('2011-11-13','yyyy-mm-dd')),
partition p20111114 values less than (to_date('2011-11-14','yyyy-mm-dd')),
partition p20111115 values less than (to_date('2011-11-15','yyyy-mm-dd')),
partition p20111116 values less than (to_date('2011-11-16','yyyy-mm-dd')),
partition p20111117 values less than (to_date('2011-11-17','yyyy-mm-dd')),
partition p20111118 values less than (to_date('2011-11-18','yyyy-mm-dd')),
partition p20111119 values less than (to_date('2011-11-19','yyyy-mm-dd')),
partition p20111120 values less than (to_date('2011-11-20','yyyy-mm-dd')),
partition p20111121 values less than (to_date('2011-11-21','yyyy-mm-dd')),
partition p20111122 values less than (to_date('2011-11-22','yyyy-mm-dd')),
partition p20111123 values less than (to_date('2011-11-23','yyyy-mm-dd')),
partition p20111124 values less than (to_date('2011-11-24','yyyy-mm-dd')),
partition p20111125 values less than (to_date('2011-11-25','yyyy-mm-dd')),
partition p20111126 values less than (to_date('2011-11-26','yyyy-mm-dd')),
partition p20111127 values less than (to_date('2011-11-27','yyyy-mm-dd')),
partition p20111128 values less than (to_date('2011-11-28','yyyy-mm-dd')),
partition p20111129 values less than (to_date('2011-11-29','yyyy-mm-dd')),
partition p20111130 values less than (to_date('2011-11-30','yyyy-mm-dd')),
partition p20111201 values less than (to_date('2011-12-01','yyyy-mm-dd')),
partition p20111202 values less than (to_date('2011-12-02','yyyy-mm-dd')),
partition p20111203 values less than (to_date('2011-12-03','yyyy-mm-dd')),
partition p20111204 values less than (to_date('2011-12-04','yyyy-mm-dd')),
partition p20111205 values less than (to_date('2011-12-05','yyyy-mm-dd')),
partition p20111206 values less than (to_date('2011-12-06','yyyy-mm-dd')),
partition p20111207 values less than (to_date('2011-12-07','yyyy-mm-dd')),
partition p20111208 values less than (to_date('2011-12-08','yyyy-mm-dd')),
partition p20111209 values less than (to_date('2011-12-09','yyyy-mm-dd')),
partition p20111210 values less than (to_date('2011-12-10','yyyy-mm-dd')),
partition p20111211 values less than (to_date('2011-12-11','yyyy-mm-dd')),
partition p20111212 values less than (to_date('2011-12-12','yyyy-mm-dd')),
partition p20111213 values less than (to_date('2011-12-13','yyyy-mm-dd')),
partition p20111214 values less than (to_date('2011-12-14','yyyy-mm-dd')),
partition p20111215 values less than (to_date('2011-12-15','yyyy-mm-dd')),
partition p20111216 values less than (to_date('2011-12-16','yyyy-mm-dd')),
partition p20111217 values less than (to_date('2011-12-17','yyyy-mm-dd')),
partition p20111218 values less than (to_date('2011-12-18','yyyy-mm-dd')),
partition p20111219 values less than (to_date('2011-12-19','yyyy-mm-dd')),
partition p20111220 values less than (to_date('2011-12-20','yyyy-mm-dd')),
partition p20111221 values less than (to_date('2011-12-21','yyyy-mm-dd')),
partition p20111222 values less than (to_date('2011-12-22','yyyy-mm-dd')),
partition p20111223 values less than (to_date('2011-12-23','yyyy-mm-dd')),
partition p20111224 values less than (to_date('2011-12-24','yyyy-mm-dd')),
partition p20111225 values less than (to_date('2011-12-25','yyyy-mm-dd')),
partition p20111226 values less than (to_date('2011-12-26','yyyy-mm-dd')),
partition p20111227 values less than (to_date('2011-12-27','yyyy-mm-dd')),
partition p20111228 values less than (to_date('2011-12-28','yyyy-mm-dd')),
partition p20111229 values less than (to_date('2011-12-29','yyyy-mm-dd')),
partition p20111230 values less than (to_date('2011-12-30','yyyy-mm-dd')),
partition p20111231 values less than (to_date('2011-12-31','yyyy-mm-dd')),
partition p20120101 values less than (to_date('2012-01-01','yyyy-mm-dd')),
partition p20120102 values less than (to_date('2012-01-02','yyyy-mm-dd')),
partition p20120103 values less than (to_date('2012-01-03','yyyy-mm-dd')),
partition p20120104 values less than (to_date('2012-01-04','yyyy-mm-dd')),
partition p20120105 values less than (to_date('2012-01-05','yyyy-mm-dd')),
partition p20120106 values less than (to_date('2012-01-06','yyyy-mm-dd')),
partition p20120107 values less than (to_date('2012-01-07','yyyy-mm-dd')),
partition p20120108 values less than (to_date('2012-01-08','yyyy-mm-dd')),
partition p20120109 values less than (to_date('2012-01-09','yyyy-mm-dd')),
partition p20120110 values less than (to_date('2012-01-10','yyyy-mm-dd')),
partition p20120111 values less than (to_date('2012-01-11','yyyy-mm-dd')),
partition p20120112 values less than (to_date('2012-01-12','yyyy-mm-dd')),
partition p20120113 values less than (to_date('2012-01-13','yyyy-mm-dd')),
partition p20120114 values less than (to_date('2012-01-14','yyyy-mm-dd')),
partition p20120115 values less than (to_date('2012-01-15','yyyy-mm-dd')),
partition p20120116 values less than (to_date('2012-01-16','yyyy-mm-dd')),
partition p20120117 values less than (to_date('2012-01-17','yyyy-mm-dd')),
partition p20120118 values less than (to_date('2012-01-18','yyyy-mm-dd')),
partition p20120119 values less than (to_date('2012-01-19','yyyy-mm-dd')),
partition p20120120 values less than (to_date('2012-01-20','yyyy-mm-dd')),
partition p20120121 values less than (to_date('2012-01-21','yyyy-mm-dd')),
partition p20120122 values less than (to_date('2012-01-22','yyyy-mm-dd')),
partition p20120123 values less than (to_date('2012-01-23','yyyy-mm-dd')),
partition p20120124 values less than (to_date('2012-01-24','yyyy-mm-dd')),
partition p20120125 values less than (to_date('2012-01-25','yyyy-mm-dd')),
partition p20120126 values less than (to_date('2012-01-26','yyyy-mm-dd')),
partition p20120127 values less than (to_date('2012-01-27','yyyy-mm-dd')),
partition p20120128 values less than (to_date('2012-01-28','yyyy-mm-dd')),
partition p20120129 values less than (to_date('2012-01-29','yyyy-mm-dd')),
partition p20120130 values less than (to_date('2012-01-30','yyyy-mm-dd')),
partition p20120131 values less than (to_date('2012-01-31','yyyy-mm-dd')),
partition p20120201 values less than (to_date('2012-02-01','yyyy-mm-dd')),
partition p20120202 values less than (to_date('2012-02-02','yyyy-mm-dd')),
partition p20120203 values less than (to_date('2012-02-03','yyyy-mm-dd')),
partition p20120204 values less than (to_date('2012-02-04','yyyy-mm-dd')),
partition p20120205 values less than (to_date('2012-02-05','yyyy-mm-dd')),
partition p20120206 values less than (to_date('2012-02-06','yyyy-mm-dd')),
partition p20120207 values less than (to_date('2012-02-07','yyyy-mm-dd')),
partition p20120208 values less than (to_date('2012-02-08','yyyy-mm-dd')),
partition p20120209 values less than (to_date('2012-02-09','yyyy-mm-dd')),
partition p20120210 values less than (to_date('2012-02-10','yyyy-mm-dd')),
partition p20120211 values less than (to_date('2012-02-11','yyyy-mm-dd')),
partition p20120212 values less than (to_date('2012-02-12','yyyy-mm-dd')),
partition p20120213 values less than (to_date('2012-02-13','yyyy-mm-dd')),
partition p20120214 values less than (to_date('2012-02-14','yyyy-mm-dd')),
partition p20120215 values less than (to_date('2012-02-15','yyyy-mm-dd')),
partition p20120216 values less than (to_date('2012-02-16','yyyy-mm-dd')),
partition p20120217 values less than (to_date('2012-02-17','yyyy-mm-dd')),
partition p20120218 values less than (to_date('2012-02-18','yyyy-mm-dd')),
partition p20120219 values less than (to_date('2012-02-19','yyyy-mm-dd')),
partition p20120220 values less than (to_date('2012-02-20','yyyy-mm-dd')),
partition p20120221 values less than (to_date('2012-02-21','yyyy-mm-dd')),
partition p20120222 values less than (to_date('2012-02-22','yyyy-mm-dd')),
partition p20120223 values less than (to_date('2012-02-23','yyyy-mm-dd')),
partition p20120224 values less than (to_date('2012-02-24','yyyy-mm-dd')),
partition p20120225 values less than (to_date('2012-02-25','yyyy-mm-dd')),
partition p20120226 values less than (to_date('2012-02-26','yyyy-mm-dd')),
partition p20120227 values less than (to_date('2012-02-27','yyyy-mm-dd')),
partition p20120228 values less than (to_date('2012-02-28','yyyy-mm-dd')),
partition p20120229 values less than (to_date('2012-02-29','yyyy-mm-dd')),
partition p20120301 values less than (to_date('2012-03-01','yyyy-mm-dd')),
partition p20120302 values less than (to_date('2012-03-02','yyyy-mm-dd')),
partition p20120303 values less than (to_date('2012-03-03','yyyy-mm-dd')),
partition p20120304 values less than (to_date('2012-03-04','yyyy-mm-dd')),
partition p20120305 values less than (to_date('2012-03-05','yyyy-mm-dd')),
partition p20120306 values less than (to_date('2012-03-06','yyyy-mm-dd')),
partition p20120307 values less than (to_date('2012-03-07','yyyy-mm-dd')),
partition p20120308 values less than (to_date('2012-03-08','yyyy-mm-dd')),
partition p20120309 values less than (to_date('2012-03-09','yyyy-mm-dd')),
partition p20120310 values less than (to_date('2012-03-10','yyyy-mm-dd')),
partition p20120311 values less than (to_date('2012-03-11','yyyy-mm-dd')),
partition p20120312 values less than (to_date('2012-03-12','yyyy-mm-dd')),
partition p20120313 values less than (to_date('2012-03-13','yyyy-mm-dd')),
partition p20120314 values less than (to_date('2012-03-14','yyyy-mm-dd')),
partition p20120315 values less than (to_date('2012-03-15','yyyy-mm-dd')),
partition p20120316 values less than (to_date('2012-03-16','yyyy-mm-dd')),
partition p20120317 values less than (to_date('2012-03-17','yyyy-mm-dd')),
partition p20120318 values less than (to_date('2012-03-18','yyyy-mm-dd')),
partition p20120319 values less than (to_date('2012-03-19','yyyy-mm-dd')),
partition p20120320 values less than (to_date('2012-03-20','yyyy-mm-dd')),
partition p20120321 values less than (to_date('2012-03-21','yyyy-mm-dd')),
partition p20120322 values less than (to_date('2012-03-22','yyyy-mm-dd')),
partition p20120323 values less than (to_date('2012-03-23','yyyy-mm-dd')),
partition p20120324 values less than (to_date('2012-03-24','yyyy-mm-dd')),
partition p20120325 values less than (to_date('2012-03-25','yyyy-mm-dd')),
partition p20120326 values less than (to_date('2012-03-26','yyyy-mm-dd')),
partition p20120327 values less than (to_date('2012-03-27','yyyy-mm-dd')),
partition p20120328 values less than (to_date('2012-03-28','yyyy-mm-dd')),
partition p20120329 values less than (to_date('2012-03-29','yyyy-mm-dd')),
partition p20120330 values less than (to_date('2012-03-30','yyyy-mm-dd')),
partition p20120331 values less than (to_date('2012-03-31','yyyy-mm-dd')),
partition p20120401 values less than (to_date('2012-04-01','yyyy-mm-dd')),
partition p20120402 values less than (to_date('2012-04-02','yyyy-mm-dd')),
partition p20120403 values less than (to_date('2012-04-03','yyyy-mm-dd')),
partition p20120404 values less than (to_date('2012-04-04','yyyy-mm-dd')),
partition p20120405 values less than (to_date('2012-04-05','yyyy-mm-dd')),
partition p20120406 values less than (to_date('2012-04-06','yyyy-mm-dd')),
partition p20120407 values less than (to_date('2012-04-07','yyyy-mm-dd')),
partition p20120408 values less than (to_date('2012-04-08','yyyy-mm-dd')),
partition p20120409 values less than (to_date('2012-04-09','yyyy-mm-dd')),
partition p20120410 values less than (to_date('2012-04-10','yyyy-mm-dd')),
partition p20120411 values less than (to_date('2012-04-11','yyyy-mm-dd')),
partition p20120412 values less than (to_date('2012-04-12','yyyy-mm-dd')),
partition p20120413 values less than (to_date('2012-04-13','yyyy-mm-dd')),
partition p20120414 values less than (to_date('2012-04-14','yyyy-mm-dd')),
partition p20120415 values less than (to_date('2012-04-15','yyyy-mm-dd')),
partition p20120416 values less than (to_date('2012-04-16','yyyy-mm-dd')),
partition p20120417 values less than (to_date('2012-04-17','yyyy-mm-dd')),
partition p20120418 values less than (to_date('2012-04-18','yyyy-mm-dd')),
partition p20120419 values less than (to_date('2012-04-19','yyyy-mm-dd')),
partition p20120420 values less than (to_date('2012-04-20','yyyy-mm-dd')),
partition p20120421 values less than (to_date('2012-04-21','yyyy-mm-dd')),
partition p20120422 values less than (to_date('2012-04-22','yyyy-mm-dd')),
partition p20120423 values less than (to_date('2012-04-23','yyyy-mm-dd')),
partition p20120424 values less than (to_date('2012-04-24','yyyy-mm-dd')),
partition p20120425 values less than (to_date('2012-04-25','yyyy-mm-dd')),
partition p20120426 values less than (to_date('2012-04-26','yyyy-mm-dd')),
partition p20120427 values less than (to_date('2012-04-27','yyyy-mm-dd')),
partition p20120428 values less than (to_date('2012-04-28','yyyy-mm-dd')),
partition p20120429 values less than (to_date('2012-04-29','yyyy-mm-dd')),
partition p20120430 values less than (to_date('2012-04-30','yyyy-mm-dd')),
partition p20120501 values less than (to_date('2012-05-01','yyyy-mm-dd')),
partition p20120502 values less than (to_date('2012-05-02','yyyy-mm-dd')),
partition p20120503 values less than (to_date('2012-05-03','yyyy-mm-dd')),
partition p20120504 values less than (to_date('2012-05-04','yyyy-mm-dd')),
partition p20120505 values less than (to_date('2012-05-05','yyyy-mm-dd')),
partition p20120506 values less than (to_date('2012-05-06','yyyy-mm-dd')),
partition p20120507 values less than (to_date('2012-05-07','yyyy-mm-dd')),
partition p20120508 values less than (to_date('2012-05-08','yyyy-mm-dd')),
partition p20120509 values less than (to_date('2012-05-09','yyyy-mm-dd')),
partition p20120510 values less than (to_date('2012-05-10','yyyy-mm-dd')),
partition p20120511 values less than (to_date('2012-05-11','yyyy-mm-dd')),
partition p20120512 values less than (to_date('2012-05-12','yyyy-mm-dd')),
partition p20120513 values less than (to_date('2012-05-13','yyyy-mm-dd')),
partition p20120514 values less than (to_date('2012-05-14','yyyy-mm-dd')),
partition p20120515 values less than (to_date('2012-05-15','yyyy-mm-dd')),
partition p20120516 values less than (to_date('2012-05-16','yyyy-mm-dd')),
partition p20120517 values less than (to_date('2012-05-17','yyyy-mm-dd')),
partition p20120518 values less than (to_date('2012-05-18','yyyy-mm-dd')),
partition p20120519 values less than (to_date('2012-05-19','yyyy-mm-dd')),
partition p20120520 values less than (to_date('2012-05-20','yyyy-mm-dd')),
partition p20120521 values less than (to_date('2012-05-21','yyyy-mm-dd')),
partition p20120522 values less than (to_date('2012-05-22','yyyy-mm-dd')),
partition p20120523 values less than (to_date('2012-05-23','yyyy-mm-dd')),
partition p20120524 values less than (to_date('2012-05-24','yyyy-mm-dd')),
partition p20120525 values less than (to_date('2012-05-25','yyyy-mm-dd')),
partition p20120526 values less than (to_date('2012-05-26','yyyy-mm-dd')),
partition p20120527 values less than (to_date('2012-05-27','yyyy-mm-dd')),
partition p20120528 values less than (to_date('2012-05-28','yyyy-mm-dd')),
partition p20120529 values less than (to_date('2012-05-29','yyyy-mm-dd')),
partition p20120530 values less than (to_date('2012-05-30','yyyy-mm-dd')),
partition p20120531 values less than (to_date('2012-05-31','yyyy-mm-dd')),
partition p20120601 values less than (to_date('2012-06-01','yyyy-mm-dd')),
partition p20120602 values less than (to_date('2012-06-02','yyyy-mm-dd')),
partition p20120603 values less than (to_date('2012-06-03','yyyy-mm-dd')),
partition p20120604 values less than (to_date('2012-06-04','yyyy-mm-dd')),
partition p20120605 values less than (to_date('2012-06-05','yyyy-mm-dd')),
partition p20120606 values less than (to_date('2012-06-06','yyyy-mm-dd')),
partition p20120607 values less than (to_date('2012-06-07','yyyy-mm-dd')),
partition p20120608 values less than (to_date('2012-06-08','yyyy-mm-dd')),
partition p20120609 values less than (to_date('2012-06-09','yyyy-mm-dd')),
partition p20120610 values less than (to_date('2012-06-10','yyyy-mm-dd')),
partition p20120611 values less than (to_date('2012-06-11','yyyy-mm-dd')),
partition p20120612 values less than (to_date('2012-06-12','yyyy-mm-dd')),
partition p20120613 values less than (to_date('2012-06-13','yyyy-mm-dd')),
partition p20120614 values less than (to_date('2012-06-14','yyyy-mm-dd')),
partition p20120615 values less than (to_date('2012-06-15','yyyy-mm-dd')),
partition p20120616 values less than (to_date('2012-06-16','yyyy-mm-dd')),
partition p20120617 values less than (to_date('2012-06-17','yyyy-mm-dd')),
partition p20120618 values less than (to_date('2012-06-18','yyyy-mm-dd')),
partition p20120619 values less than (to_date('2012-06-19','yyyy-mm-dd')),
partition p20120620 values less than (to_date('2012-06-20','yyyy-mm-dd')),
partition p20120621 values less than (to_date('2012-06-21','yyyy-mm-dd')),
partition p20120622 values less than (to_date('2012-06-22','yyyy-mm-dd')),
partition p20120623 values less than (to_date('2012-06-23','yyyy-mm-dd')),
partition p20120624 values less than (to_date('2012-06-24','yyyy-mm-dd')),
partition p20120625 values less than (to_date('2012-06-25','yyyy-mm-dd')),
partition p20120626 values less than (to_date('2012-06-26','yyyy-mm-dd')),
partition p20120627 values less than (to_date('2012-06-27','yyyy-mm-dd')),
partition p20120628 values less than (to_date('2012-06-28','yyyy-mm-dd')),
partition p20120629 values less than (to_date('2012-06-29','yyyy-mm-dd')),
partition p20120630 values less than (to_date('2012-06-30','yyyy-mm-dd')),
partition p20120701 values less than (to_date('2012-07-01','yyyy-mm-dd')),
partition p20120702 values less than (to_date('2012-07-02','yyyy-mm-dd')),
partition p20120703 values less than (to_date('2012-07-03','yyyy-mm-dd')),
partition p20120704 values less than (to_date('2012-07-04','yyyy-mm-dd')),
partition p20120705 values less than (to_date('2012-07-05','yyyy-mm-dd')),
partition p20120706 values less than (to_date('2012-07-06','yyyy-mm-dd')),
partition p20120707 values less than (to_date('2012-07-07','yyyy-mm-dd')),
partition p20120708 values less than (to_date('2012-07-08','yyyy-mm-dd')),
partition p20120709 values less than (to_date('2012-07-09','yyyy-mm-dd')),
partition p20120710 values less than (to_date('2012-07-10','yyyy-mm-dd')),
partition p20120711 values less than (to_date('2012-07-11','yyyy-mm-dd')),
partition p20120712 values less than (to_date('2012-07-12','yyyy-mm-dd')),
partition p20120713 values less than (to_date('2012-07-13','yyyy-mm-dd')),
partition p20120714 values less than (to_date('2012-07-14','yyyy-mm-dd')),
partition p20120715 values less than (to_date('2012-07-15','yyyy-mm-dd')),
partition p20120716 values less than (to_date('2012-07-16','yyyy-mm-dd')),
partition p20120717 values less than (to_date('2012-07-17','yyyy-mm-dd')),
partition p20120718 values less than (to_date('2012-07-18','yyyy-mm-dd')),
partition p20120719 values less than (to_date('2012-07-19','yyyy-mm-dd')),
partition p20120720 values less than (to_date('2012-07-20','yyyy-mm-dd')),
partition p20120721 values less than (to_date('2012-07-21','yyyy-mm-dd')),
partition p20120722 values less than (to_date('2012-07-22','yyyy-mm-dd')),
partition p20120723 values less than (to_date('2012-07-23','yyyy-mm-dd')),
partition p20120724 values less than (to_date('2012-07-24','yyyy-mm-dd')),
partition p20120725 values less than (to_date('2012-07-25','yyyy-mm-dd')),
partition p20120726 values less than (to_date('2012-07-26','yyyy-mm-dd')),
partition p20120727 values less than (to_date('2012-07-27','yyyy-mm-dd')),
partition p20120728 values less than (to_date('2012-07-28','yyyy-mm-dd')),
partition p20120729 values less than (to_date('2012-07-29','yyyy-mm-dd')),
partition p20120730 values less than (to_date('2012-07-30','yyyy-mm-dd')),
partition p20120731 values less than (to_date('2012-07-31','yyyy-mm-dd')),
partition p20120801 values less than (to_date('2012-08-01','yyyy-mm-dd')),
partition p20120802 values less than (to_date('2012-08-02','yyyy-mm-dd')),
partition p20120803 values less than (to_date('2012-08-03','yyyy-mm-dd')),
partition p20120804 values less than (to_date('2012-08-04','yyyy-mm-dd')),
partition p20120805 values less than (to_date('2012-08-05','yyyy-mm-dd')),
partition p20120806 values less than (to_date('2012-08-06','yyyy-mm-dd')),
partition p20120807 values less than (to_date('2012-08-07','yyyy-mm-dd')),
partition p20120808 values less than (to_date('2012-08-08','yyyy-mm-dd')),
partition p20120809 values less than (to_date('2012-08-09','yyyy-mm-dd')),
partition p20120810 values less than (to_date('2012-08-10','yyyy-mm-dd')),
partition p20120811 values less than (to_date('2012-08-11','yyyy-mm-dd')),
partition p20120812 values less than (to_date('2012-08-12','yyyy-mm-dd')),
partition p20120813 values less than (to_date('2012-08-13','yyyy-mm-dd')),
partition p20120814 values less than (to_date('2012-08-14','yyyy-mm-dd')),
partition p20120815 values less than (to_date('2012-08-15','yyyy-mm-dd')),
partition p20120816 values less than (to_date('2012-08-16','yyyy-mm-dd')),
partition p20120817 values less than (to_date('2012-08-17','yyyy-mm-dd')),
partition p20120818 values less than (to_date('2012-08-18','yyyy-mm-dd')),
partition p20120819 values less than (to_date('2012-08-19','yyyy-mm-dd')),
partition p20120820 values less than (to_date('2012-08-20','yyyy-mm-dd')),
partition p20120821 values less than (to_date('2012-08-21','yyyy-mm-dd')),
partition p20120822 values less than (to_date('2012-08-22','yyyy-mm-dd')),
partition p20120823 values less than (to_date('2012-08-23','yyyy-mm-dd')),
partition p20120824 values less than (to_date('2012-08-24','yyyy-mm-dd')),
partition p20120825 values less than (to_date('2012-08-25','yyyy-mm-dd')),
partition p20120826 values less than (to_date('2012-08-26','yyyy-mm-dd')),
partition p20120827 values less than (to_date('2012-08-27','yyyy-mm-dd')),
partition p20120828 values less than (to_date('2012-08-28','yyyy-mm-dd')),
partition p20120829 values less than (to_date('2012-08-29','yyyy-mm-dd')),
partition p20120830 values less than (to_date('2012-08-30','yyyy-mm-dd')),
partition p20120831 values less than (to_date('2012-08-31','yyyy-mm-dd')),
partition p20120901 values less than (to_date('2012-09-01','yyyy-mm-dd')),
partition p20120902 values less than (to_date('2012-09-02','yyyy-mm-dd')),
partition p20120903 values less than (to_date('2012-09-03','yyyy-mm-dd')),
partition p20120904 values less than (to_date('2012-09-04','yyyy-mm-dd')),
partition p20120905 values less than (to_date('2012-09-05','yyyy-mm-dd')),
partition p20120906 values less than (to_date('2012-09-06','yyyy-mm-dd')),
partition p20120907 values less than (to_date('2012-09-07','yyyy-mm-dd')),
partition p20120908 values less than (to_date('2012-09-08','yyyy-mm-dd')),
partition p20120909 values less than (to_date('2012-09-09','yyyy-mm-dd')),
partition p20120910 values less than (to_date('2012-09-10','yyyy-mm-dd')),
partition p20120911 values less than (to_date('2012-09-11','yyyy-mm-dd')),
partition p20120912 values less than (to_date('2012-09-12','yyyy-mm-dd')),
partition p20120913 values less than (to_date('2012-09-13','yyyy-mm-dd')),
partition p20120914 values less than (to_date('2012-09-14','yyyy-mm-dd')),
partition p20120915 values less than (to_date('2012-09-15','yyyy-mm-dd')),
partition p20120916 values less than (to_date('2012-09-16','yyyy-mm-dd')),
partition p20120917 values less than (to_date('2012-09-17','yyyy-mm-dd')),
partition p20120918 values less than (to_date('2012-09-18','yyyy-mm-dd')),
partition p20120919 values less than (to_date('2012-09-19','yyyy-mm-dd')),
partition p20120920 values less than (to_date('2012-09-20','yyyy-mm-dd')),
partition p20120921 values less than (to_date('2012-09-21','yyyy-mm-dd')),
partition p20120922 values less than (to_date('2012-09-22','yyyy-mm-dd')),
partition p20120923 values less than (to_date('2012-09-23','yyyy-mm-dd')),
partition p20120924 values less than (to_date('2012-09-24','yyyy-mm-dd')),
partition p20120925 values less than (to_date('2012-09-25','yyyy-mm-dd')),
partition p20120926 values less than (to_date('2012-09-26','yyyy-mm-dd')),
partition p20120927 values less than (to_date('2012-09-27','yyyy-mm-dd')),
partition p20120928 values less than (to_date('2012-09-28','yyyy-mm-dd')),
partition p20120929 values less than (to_date('2012-09-29','yyyy-mm-dd')),
partition p20120930 values less than (to_date('2012-09-30','yyyy-mm-dd')),
partition p20121001 values less than (to_date('2012-10-01','yyyy-mm-dd')),
partition p20121002 values less than (to_date('2012-10-02','yyyy-mm-dd')),
partition p20121003 values less than (to_date('2012-10-03','yyyy-mm-dd')),
partition p20121004 values less than (to_date('2012-10-04','yyyy-mm-dd')),
partition p20121005 values less than (to_date('2012-10-05','yyyy-mm-dd')),
partition p20121006 values less than (to_date('2012-10-06','yyyy-mm-dd')),
partition p20121007 values less than (to_date('2012-10-07','yyyy-mm-dd')),
partition p20121008 values less than (to_date('2012-10-08','yyyy-mm-dd')),
partition p20121009 values less than (to_date('2012-10-09','yyyy-mm-dd')),
partition p20121010 values less than (to_date('2012-10-10','yyyy-mm-dd')),
partition p20121011 values less than (to_date('2012-10-11','yyyy-mm-dd')),
partition p20121012 values less than (to_date('2012-10-12','yyyy-mm-dd')),
partition p20121013 values less than (to_date('2012-10-13','yyyy-mm-dd')),
partition p20121014 values less than (to_date('2012-10-14','yyyy-mm-dd')),
partition p20121015 values less than (to_date('2012-10-15','yyyy-mm-dd')),
partition p20121016 values less than (to_date('2012-10-16','yyyy-mm-dd')),
partition p20121017 values less than (to_date('2012-10-17','yyyy-mm-dd')),
partition p20121018 values less than (to_date('2012-10-18','yyyy-mm-dd')),
partition p29991231 values less than (to_date('2999-12-31','yyyy-mm-dd')),
partition pmax values less than (maxvalue));
pmax 作用:
为了防止没有最大值，数据库没法insert
|
